Backup and Recovery Plan Using RMAN
Environment
Hostname: earth02
Unix Owner: oratst
RMAN environment: ${ORACLE_HOME}/RMAN_earth02.env
Scripts: /u12/maint_scripts/rman_scripts
Backup Directory: /u12/data/<SID>
target database Database you want to backup using RMAN
catalog Rman repository
Misc Recovery Details
v After recovering control file you must reset database to a new incarnation in RMAN catalog - Note:175768.1
v Consistent backup Database mounted but not open. Database was not shutdown with abort command or crashed.
v Inconsistent backup Requires media recover but is as valid as a consistent backup
v Verify NLS_DATE and NLS_LANG are the same in rman and target database
NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P1"
export NLS_LANG
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"
export NLS_DATE_FORMAT
v Default Device Format for test
Configure channel device type disk format ='/u12/data/bkup_%U';
RMAN Requirements
RMAN with Legato
1. Install NMO on Client (Networker Module for Oracle)
a. Backup Command: (nsrnmo script to run RMAN from Legato):
script : /usr/sbin/nsrnmo9i
owner : root
2. Rman backup scripts
a. Saveset:
script location : /u12/maint_scripts/rman_scripts
owner : oraprd
Setup Target Database to use RMAN
1. Set target database to archivelog mode
Startup mount
alter database archivelog;
alter database noarchivelog;
alter database open
Alter system archive log start
2. Create a password file (for sysdba remote connection)
Orapwd file=orapwSID password=<password> entries=10
3. Add line to init.ora file:
Remote_login_passwordfile=exclusive
4. Create a sysdba user in Target for RMAN connection
Create user rman identified by rman
Default tablespace tools
Default temp tablespace temp;
Grant create session, sysdba to rman;
Setup RMAN instance to use Catalog
1. Create RMAN instance
Create tablespace for catalog
Update tnsnames.ora with databases that will use RMAN
2. Create RMAN user:
grant recovery_catalog_owner to rman;
grant connect,resource,sysdba to rman
3. Create rman catalog
rman catalog rman/rman@rman msglog = catalog.log
create catalog tablespace 'CATALOG';
exit;
4. Register database:
source SID.env OF database with Updated TNSNAMES.ora
>rman target rman/rman9@<ORACLE_SID>
>connect catalog rman/rman@rman
>register database;
Rman Commands
a. Connect to rman
rman catalog rman/rman9@rman target rman/rman9@target
b. Show default configuration
Connect to target and rman:
rman catalog rman/rman9@rman
RMAN> target rman/rman9@tcmdb
RMAN> SHOW ALL; (Default)
Automatic Configuration Environment:
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 3;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_DATA_VOLUME_POOL=HADallasUnixTest)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u10/oracle/testdb/9.2.0/dbs/snapcf_TCMDB.f';
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u10/oracle/testdb/9.2.0/dbs/snapcf_TCMDB.f'; # default
Parameters in PROD_US
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 60 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 3;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_DATA_VOLUME_POOL=HADallasRmanUnix)';
CONFIGURE MAXSETSIZE TO 2097152 K;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/proddb/9.2.0/dbs/snapcf_PROD.f'; # default
b. Commands to find information required for Recovery
unregister database;
execute dbms_rcvcat.unregisterdatabase (db_key, db_id)
Find db_key db_id:
select * from rc_database;
Recreate snapshot controlfile destination from target as sys:
execute sys.dbms_backup_RESTORE.CFILESETSNAPSHOTNAME('/u10/oracle/prddb/9.2.0/dbs/snapcf_PBIR.f'); execute
1. Check Log #'s:
select max(next_change#) scn
from v$archived_log
group by thread#;
select max(next_change#)
from v$archived_log
where archived='YES'
group by thread#;
select max(next_change#) from v$log_history;
1145081 1145082 263561676 PBIR
2. select * from rc_database_incarnation;
dbkey=2832
a. select dbinc_key, dbid,resetlogs_change# from rc_database_incarnation 2;
Find the seq# of the CATALOGED archived log files
Query the RMAN catalog:
3. select i.DBID,a.DB_KEY,a.DBINC_KEY,a.DB_NAME,SEQUENCE#,a.FIRST_CHANGE#,a.NEXT_CHANGE#,a.COMPLETION_TIME,a.STATUS
from RC_ARCHIVED_LOG a, rc_database_incarnation i
where a.DBINC_KEY = i.DBINC_KEY and i.CURRENT_INCARNATION='YES'
and i.DBID=1519956463
order by SEQUENCE#;
c. Commands to maintain Recovery Catalog
allocate channel for maintenance device type disk;
allocate channel for maintenance device type sbt;
crosscheck backup;
crosscheck copy;
delete expired backup;
delete expired copy;
release channel;
allocate channel for maintenance device type sbt;
delete obsolete;
release channel;
d. Additional RMAN commands:
a. reset database (Used after recovering control file) Note:175768.1
b. List incarnation of database;
c. Reset database to incarnation inc_key:;
You can run a test RMAN backup that does not generate
any output. The test checks datafiles for physical and logical corruption and
that all database files exist and are in the correct locations
d. BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
.
e Create an image copy
COPY DATAFILE 1 TO '/tmp/df1.cpy', CURRENT CONTROLFILE TO '/tmp/cf.cpy';
Recovery Scenarios
1. Restore Control file
startup mount;
restore controlfile;
alter database mount;
# you must run the RECOVER command after restoring a control file even if no datafiles require recovery
recover database;
alter database open resetlogs;
# if the database uses locally -
Did not run until time:
restore with either until time or last backup:
run {
2> set until time '19-JUN-2003 15:39:56';
3> allocate channel t1 type 'SBT_TAPE';
4> restore controlfile;
Ran the following script to restore control file:
v Recover control file script: TCMDB_recover_ctrlfile.rcv
run {
allocate channel D1 type DISK;
restore controlfile;
alter database mount;
recover database;
}
JAMES' version
SCRIPT: BUTEST_recover_ctrlfile.rcv
connect rcvcat rman/rman9@rman
Connect target rman/rman9@butest
#
# Need to know the name of the backup you are pulling from
#
run {
allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(NSR_DATE_VOLUME_POOL=HADallasUnixTest, NSR_DEBUG_FILE=/tmp/recover_BUTEST_ctrlfile.log)';
restore controlfile from 'bu_BUTEST_s3p1t564339234_03gq67hq'
}
Perform a normal database recovery at that point.
2. Recover dropped system datafile
Recover a dropped datafile
RUN
{
SQL 'ALTER DATABASE DATAFILE 7 OFFLINE';
# To restore to a different location, uncomment the following command.
# SET NEWNAME FOR DATAFILE 7 TO '/newdir/new_filename.f';
RESTORE DATAFILE 7;
# If you restored to different locations, uncomment the following line.
# SWITCH DATAFILE ALL;
RECOVER DATAFILE 7;
SQL 'ALTER DATABASE DATAFILE 7 ONLINE';
}
Clone Database:
The cloned database is referred to as the Auxillary database in Rman
Setup Auxillary database environment the same as environment as the Target Database.
Add these entries to the init.ora file of the cloned database.
Recover Scenario Output
Clone database:
Recovery Manager: Release 9.2.0.5.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect catalog rman/rman9@RMAN;
2> connect target rman/rman9@TCMDB;
3> connect auxiliary sys/m1rage@NEWDB;
4>
5> #
6> # Clone the TCMDB database to NEWDB on the same machine
7> #
8>
9> run {
10> allocate auxiliary channel t1 type DISK;
11> allocate channel d1 type DISK;
12> set until SCN 27819646;
13> duplicate target database to NEWDB;
14> }
15>
connected to recovery catalog database
connected to target database: TCMDB (DBID=2386221693)
connected to auxiliary database: NEWDB (not mounted)
allocated channel: t1
channel t1: sid=11 devtype=DISK
allocated channel: d1
channel d1: sid=15 devtype=DISK
executing command: SET until clause
Starting Duplicate Db at 15-NOV-05
printing stored script: Memory Script
{
set until scn 27819646;
set newname for datafile 1 to
"/u09/oracle/newdbdata/system01.dbf";
set newname for datafile 2 to
"/u11/oracle/newdbdata/undotbs01.dbf";
set newname for datafile 3 to
"/u11/oracle/newdbdata/writerd01.dbf";
set newname for datafile 4 to
"/u09/oracle/newdbdata/writerx01.dbf";
set newname for datafile 5 to
"/u11/oracle/newdbdata/writerrepod01.dbf";
set newname for datafile 6 to
"/u09/oracle/newdbdata/writerrepox01.dbf";
set newname for datafile 7 to
"/u11/oracle/newdbdata/ovdbd01.dbf";
set newname for datafile 8 to
"/u09/oracle/newdbdata/ovdbx01.dbf";
set newname for datafile 9 to
"/u11/oracle/newdbdata/tools01.dbf";
set newname for datafile 10 to
"/u11/oracle/newdbdata/sdd01.dbf";
set newname for datafile 11 to
"/u09/oracle/newdbdata/sdx01.dbf";
set newname for datafile 12 to
"/u11/oracle/newdbdata/rdd01.dbf";
set newname for datafile 13 to
"/u09/oracle/newdbdata/rdx01.dbf";
set newname for datafile 14 to
"/u11/oracle/newdbdata/cmgmtd01.dbf";
set newname for datafile 15 to
"/u11/oracle/newdbdata/sdeskd01.dbf";
set newname for datafile 16 to
"/u09/oracle/newdbdata/sdeskx01.dbf";
set newname for datafile 17 to
"/u09/oracle/newdbdata/cmgmtx01.dbf";
restore
check readonly
clone database
;
}
executing script: Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 15-NOV-05
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u09/oracle/newdbdata/system01.dbf
restoring datafile 00004 to /u09/oracle/newdbdata/writerx01.dbf
restoring datafile 00007 to /u11/oracle/newdbdata/ovdbd01.dbf
restoring datafile 00011 to /u09/oracle/newdbdata/sdx01.dbf
channel t1: restored backup piece 1
piece handle=/u12/data/TCMDB/bu_TCMDB_j3h3qftu tag=TAG20051115T142918 params=NULL
channel t1: restore complete
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /u11/oracle/newdbdata/writerd01.dbf
restoring datafile 00005 to /u11/oracle/newdbdata/writerrepod01.dbf
restoring datafile 00014 to /u11/oracle/newdbdata/cmgmtd01.dbf
restoring datafile 00015 to /u11/oracle/newdbdata/sdeskd01.dbf
channel t1: restored backup piece 1
piece handle=/u12/data/TCMDB/bu_TCMDB_j4h3qg0t tag=TAG20051115T142918 params=NULL
channel t1: restore complete
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u11/oracle/newdbdata/undotbs01.dbf
restoring datafile 00009 to /u11/oracle/newdbdata/tools01.dbf
restoring datafile 00010 to /u11/oracle/newdbdata/sdd01.dbf
restoring datafile 00012 to /u11/oracle/newdbdata/rdd01.dbf
channel t1: restored backup piece 1
piece handle=/u12/data/TCMDB/bu_TCMDB_j5h3qg10 tag=TAG20051115T142918 params=NULL
channel t1: restore complete
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /u09/oracle/newdbdata/writerrepox01.dbf
restoring datafile 00008 to /u09/oracle/newdbdata/ovdbx01.dbf
restoring datafile 00013 to /u09/oracle/newdbdata/rdx01.dbf
restoring datafile 00017 to /u09/oracle/newdbdata/cmgmtx01.dbf
channel t1: restored backup piece 1
piece handle=/u12/data/TCMDB/bu_TCMDB_j6h3qg13 tag=TAG20051115T142918 params=NULL
channel t1: restore complete
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00016 to /u09/oracle/newdbdata/sdeskx01.dbf
channel t1: restored backup piece 1
piece handle=/u12/data/TCMDB/bu_TCMDB_j7h3qg14 tag=TAG20051115T142918 params=NULL
channel t1: restore complete
Finished restore at 15-NOV-05
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "NEWDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 64
MAXLOGMEMBERS 4
MAXDATAFILES 256
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
GROUP 1 ( '/u09/oracle/newdbdata/log1a.dbf', '/u11/oracle/newdbdata/log1b.dbf' ) SIZE 10485760 REUSE,
GROUP 2 ( '/u09/oracle/newdbdata/log2a.dbf', '/u11/oracle/newdbdata/log2b.dbf' ) SIZE 10485760 REUSE
DATAFILE
'/u09/oracle/newdbdata/system01.dbf'
CHARACTER SET UTF8
printing stored script: Memory Script
{
switch clone datafile all;
}
executing script: Memory Script
datafile 2 switched to datafile copy
input datafilecopy recid=1 stamp=574442499 filename=/u11/oracle/newdbdata/undotbs01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=2 stamp=574442499 filename=/u11/oracle/newdbdata/writerd01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=3 stamp=574442499 filename=/u09/oracle/newdbdata/writerx01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=4 stamp=574442499 filename=/u11/oracle/newdbdata/writerrepod01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=5 stamp=574442499 filename=/u09/oracle/newdbdata/writerrepox01.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=6 stamp=574442499 filename=/u11/oracle/newdbdata/ovdbd01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=7 stamp=574442499 filename=/u09/oracle/newdbdata/ovdbx01.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=8 stamp=574442499 filename=/u11/oracle/newdbdata/tools01.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=9 stamp=574442499 filename=/u11/oracle/newdbdata/sdd01.dbf
datafile 11 switched to datafile copy
input datafilecopy recid=10 stamp=574442499 filename=/u09/oracle/newdbdata/sdx01.dbf
datafile 12 switched to datafile copy
input datafilecopy recid=11 stamp=574442499 filename=/u11/oracle/newdbdata/rdd01.dbf
datafile 13 switched to datafile copy
input datafilecopy recid=12 stamp=574442499 filename=/u09/oracle/newdbdata/rdx01.dbf
datafile 14 switched to datafile copy
input datafilecopy recid=13 stamp=574442499 filename=/u11/oracle/newdbdata/cmgmtd01.dbf
datafile 15 switched to datafile copy
input datafilecopy recid=14 stamp=574442499 filename=/u11/oracle/newdbdata/sdeskd01.dbf
datafile 16 switched to datafile copy
input datafilecopy recid=15 stamp=574442499 filename=/u09/oracle/newdbdata/sdeskx01.dbf
datafile 17 switched to datafile copy
input datafilecopy recid=16 stamp=574442499 filename=/u09/oracle/newdbdata/cmgmtx01.dbf
printing stored script: Memory Script
{
set until scn 27819646;
recover
clone database
delete archivelog
;
}
executing script: Memory Script
executing command: SET until clause
Starting recover at 15-NOV-05
starting media recovery
archive log thread 1 sequence 1 is already on disk as file /u10/oracle/testdb/9.2.0/admin/TCMDB_earth02/arch/arch_1.log
archive log filename=/u10/oracle/testdb/9.2.0/admin/TCMDB_earth02/arch/arch_1.log thread=1 sequence=1
media recovery complete
Finished recover at 15-NOV-05
printing stored script: Memory Script
{
shutdown clone;
startup clone nomount ;
}
executing script: Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 303650068 bytes
Fixed Size 455956 bytes
Variable Size 167772160 bytes
Database Buffers 134217728 bytes
Redo Buffers 1204224 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "NEWDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 64
MAXLOGMEMBERS 4
MAXDATAFILES 256
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
GROUP 1 ( '/u09/oracle/newdbdata/log1a.dbf', '/u11/oracle/newdbdata/log1b.dbf' ) SIZE 10485760 REUSE,
GROUP 2 ( '/u09/oracle/newdbdata/log2a.dbf', '/u11/oracle/newdbdata/log2b.dbf' ) SIZE 10485760 REUSE
DATAFILE
'/u09/oracle/newdbdata/system01.dbf'
CHARACTER SET UTF8
printing stored script: Memory Script
{
catalog clone datafilecopy "/u11/oracle/newdbdata/undotbs01.dbf";
catalog clone datafilecopy "/u11/oracle/newdbdata/writerd01.dbf";
catalog clone datafilecopy "/u09/oracle/newdbdata/writerx01.dbf";
catalog clone datafilecopy "/u11/oracle/newdbdata/writerrepod01.dbf";
catalog clone datafilecopy "/u09/oracle/newdbdata/writerrepox01.dbf";
catalog clone datafilecopy "/u11/oracle/newdbdata/ovdbd01.dbf";
catalog clone datafilecopy "/u09/oracle/newdbdata/ovdbx01.dbf";
catalog clone datafilecopy "/u11/oracle/newdbdata/tools01.dbf";
catalog clone datafilecopy "/u11/oracle/newdbdata/sdd01.dbf";
catalog clone datafilecopy "/u09/oracle/newdbdata/sdx01.dbf";
catalog clone datafilecopy "/u11/oracle/newdbdata/rdd01.dbf";
catalog clone datafilecopy "/u09/oracle/newdbdata/rdx01.dbf";
catalog clone datafilecopy "/u11/oracle/newdbdata/cmgmtd01.dbf";
catalog clone datafilecopy "/u11/oracle/newdbdata/sdeskd01.dbf";
catalog clone datafilecopy "/u09/oracle/newdbdata/sdeskx01.dbf";
catalog clone datafilecopy "/u09/oracle/newdbdata/cmgmtx01.dbf";
switch clone datafile all;
}
executing script: Memory Script
cataloged datafile copy
datafile copy filename=/u11/oracle/newdbdata/undotbs01.dbf recid=1 stamp=574442592
cataloged datafile copy
datafile copy filename=/u11/oracle/newdbdata/writerd01.dbf recid=2 stamp=574442592
cataloged datafile copy
datafile copy filename=/u09/oracle/newdbdata/writerx01.dbf recid=3 stamp=574442593
cataloged datafile copy
datafile copy filename=/u11/oracle/newdbdata/writerrepod01.dbf recid=4 stamp=574442593
cataloged datafile copy
datafile copy filename=/u09/oracle/newdbdata/writerrepox01.dbf recid=5 stamp=574442593
cataloged datafile copy
datafile copy filename=/u11/oracle/newdbdata/ovdbd01.dbf recid=6 stamp=574442593
cataloged datafile copy
datafile copy filename=/u09/oracle/newdbdata/ovdbx01.dbf recid=7 stamp=574442593
cataloged datafile copy
datafile copy filename=/u11/oracle/newdbdata/tools01.dbf recid=8 stamp=574442593
cataloged datafile copy
datafile copy filename=/u11/oracle/newdbdata/sdd01.dbf recid=9 stamp=574442593
cataloged datafile copy
datafile copy filename=/u09/oracle/newdbdata/sdx01.dbf recid=10 stamp=574442593
cataloged datafile copy
datafile copy filename=/u11/oracle/newdbdata/rdd01.dbf recid=11 stamp=574442593
cataloged datafile copy
datafile copy filename=/u09/oracle/newdbdata/rdx01.dbf recid=12 stamp=574442593
cataloged datafile copy
datafile copy filename=/u11/oracle/newdbdata/cmgmtd01.dbf recid=13 stamp=574442593
cataloged datafile copy
datafile copy filename=/u11/oracle/newdbdata/sdeskd01.dbf recid=14 stamp=574442593
cataloged datafile copy
datafile copy filename=/u09/oracle/newdbdata/sdeskx01.dbf recid=15 stamp=574442593
cataloged datafile copy
datafile copy filename=/u09/oracle/newdbdata/cmgmtx01.dbf recid=16 stamp=574442593
datafile 2 switched to datafile copy
input datafilecopy recid=1 stamp=574442592 filename=/u11/oracle/newdbdata/undotbs01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=2 stamp=574442592 filename=/u11/oracle/newdbdata/writerd01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=3 stamp=574442593 filename=/u09/oracle/newdbdata/writerx01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=4 stamp=574442593 filename=/u11/oracle/newdbdata/writerrepod01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=5 stamp=574442593 filename=/u09/oracle/newdbdata/writerrepox01.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=6 stamp=574442593 filename=/u11/oracle/newdbdata/ovdbd01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=7 stamp=574442593 filename=/u09/oracle/newdbdata/ovdbx01.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=8 stamp=574442593 filename=/u11/oracle/newdbdata/tools01.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=9 stamp=574442593 filename=/u11/oracle/newdbdata/sdd01.dbf
datafile 11 switched to datafile copy
input datafilecopy recid=10 stamp=574442593 filename=/u09/oracle/newdbdata/sdx01.dbf
datafile 12 switched to datafile copy
input datafilecopy recid=11 stamp=574442593 filename=/u11/oracle/newdbdata/rdd01.dbf
datafile 13 switched to datafile copy
input datafilecopy recid=12 stamp=574442593 filename=/u09/oracle/newdbdata/rdx01.dbf
datafile 14 switched to datafile copy
input datafilecopy recid=13 stamp=574442593 filename=/u11/oracle/newdbdata/cmgmtd01.dbf
datafile 15 switched to datafile copy
input datafilecopy recid=14 stamp=574442593 filename=/u11/oracle/newdbdata/sdeskd01.dbf
datafile 16 switched to datafile copy
input datafilecopy recid=15 stamp=574442593 filename=/u09/oracle/newdbdata/sdeskx01.dbf
datafile 17 switched to datafile copy
input datafilecopy recid=16 stamp=574442593 filename=/u09/oracle/newdbdata/cmgmtx01.dbf
printing stored script: Memory Script
{
Alter clone database open resetlogs;
}
executing script: Memory Script
database opened
Finished Duplicate Db at 15-NOV-05
released channel: d1
Recovery Manager complete.
Don't forget to create a temp tablespace
Well written post. I appreciate your guidance for sharing about backup disaster recovery here. I really need to know about it. Great work!
ReplyDeleteThank you for bringing more information to this topic disaster recovery. I’m truly grateful and really impressed. Absolutely this article is incredible.
ReplyDelete