Oracle Error: ORA-1157 An ORA-01157 is issued whenever Oracle attempts to access a file but cannot find or lock the file. Error...

All Oracle support Analysts, DBAs and Consultants who have a role to play in recovering an Oracle database Loss due to Disk Failure...

BACKUP SCENARIOS a) Consistent backups A consistent backup means that all data files and control files are consistent  to a point in...

% rman target / log recover_table1.log RMAN> RECOVER TABLE SMEDS.”RECTEST” OF PLUGGABLE DATABASE T12CPDB1 UNTIL SEQUENCE 48 THREAD 1 ...

Scope This bulletin gives instructions to: I. RENAME OR MOVE DATAFILE(S) WITH THE DATABASE OPEN II. RENAME AND OR MOVE DATAFILE(S) WITH...

How to automate the opening of pluggable databases after the Container DataBase (CDB) starts up? Solution Create a database startup...

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...

Oracle9i Lab 1 , but is applicable for higher RDBMS versions aswell Consistent Backup, Restore and Recovery using RMAN In Oracle9i,...

Verify the databases are in archivelog mode and archive destination. a. NODE 1: thread 1 SQL> archive log list; Database log...

Top 10 Backup and Recovery best practices. This document assumes that you are doing the Backup and Recovery basics – Running in...

Support for Container and Pluggable Databases RMAN in 12c provides full backup and recovery support for a Pluggable Database...