top of page
Search
Hanh Nguyen
Nov 10, 201511 min read
An ORA-01157 is issued whenever Oracle attempts to access a file but cannot find or lock the file.
Oracle Error: ORA-1157 An ORA-01157 is issued whenever Oracle attempts to access a file but cannot find or lock the file. Error...
0 views0 comments
Hanh Nguyen
Nov 10, 20157 min read
Recover database after disk loss
All Oracle support Analysts, DBAs and Consultants who have a role to play in recovering an Oracle database Loss due to Disk Failure...
0 views0 comments
Hanh Nguyen
Nov 10, 201510 min read
Backup and Recovery Scenarios
BACKUP SCENARIOS a) Consistent backups A consistent backup means that all data files and control files are consistent to a point in...
0 views0 comments
Hanh Nguyen
Nov 8, 20158 min read
Recover table from RMAN in 12c
% rman target / log recover_table1.log RMAN> RECOVER TABLE SMEDS.”RECTEST” OF PLUGGABLE DATABASE T12CPDB1 UNTIL SEQUENCE 48 THREAD 1 ...
0 views0 comments
Hanh Nguyen
Oct 24, 20153 min read
How to Rename or Move Datafiles and Logfiles
Scope This bulletin gives instructions to: I. RENAME OR MOVE DATAFILE(S) WITH THE DATABASE OPEN II. RENAME AND OR MOVE DATAFILE(S) WITH...
0 views0 comments
Hanh Nguyen
Oct 24, 20151 min read
How To Automate The Opening Of Pluggable Databases After The CDB Starts Up
How to automate the opening of pluggable databases after the Container DataBase (CDB) starts up? Solution Create a database startup...
1 view0 comments
Hanh Nguyen
Oct 4, 20152 min read
When to use startup / shutdown database and alter database command in 12c
Before 12c there are only few commands available for startup and shutdown but if we follow that we end up starting and stopping only cdb...
0 views0 comments
Hanh Nguyen
Oct 3, 201518 min read
Consistent Backup, Restore and Recovery using RMAN
Oracle9i Lab 1 , but is applicable for higher RDBMS versions aswell Consistent Backup, Restore and Recovery using RMAN In Oracle9i,...
1 view0 comments
Hanh Nguyen
Oct 3, 20157 min read
RAC Backup, Restore and Recovery using RMAN
Verify the databases are in archivelog mode and archive destination. a. NODE 1: thread 1 SQL> archive log list; Database log...
1 view0 comments
Hanh Nguyen
Oct 3, 20154 min read
Top 10 Backup and Recovery Best Practice
Top 10 Backup and Recovery best practices. This document assumes that you are doing the Backup and Recovery basics – Running in...
1 view0 comments
Hanh Nguyen
Oct 3, 20159 min read
RMAN Enhancements in Oracle 12c
Support for Container and Pluggable Databases RMAN in 12c provides full backup and recovery support for a Pluggable Database...
0 views0 comments
bottom of page