-
Hi,
After taking a level 0 backup of my test db using RMAN, I shutdown down the db and deleted the system01.dbf. To recover this file I used the following command
RMAN> run {
2> allocate channel c1 type disk;
3> restore tablespace "system";
4> recover tablespace "system";
5> sql 'alter database open';
6> }
Thought this would do the trick but RMAN returned these error
messages :
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=10 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "system"
Does this mean in order to use my " restore tablespace " clause I have to individually backup each of the tablespaces in my database?? The reason I'm saying this is because when I modified my RMAN comand to:
RMAN> run {
2> allocate channel c1 type disk;
3> restore database;
4> recover database;
5> sql 'alter database open';
6> }
The database is fully recovered as shown:
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=10 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel c1: starting datafile backupset restore
RMAN-08502: set_count=1 set_stamp=422737854 creation_time=26-FEB-01
RMAN-08089: channel c1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to E:\ORACLE\ORADATA\TEST\SYSTEM01.DBF
RMAN-08523: restoring datafile 00002 to E:\ORACLE\ORADATA\TEST\RBS01.DBF
RMAN-08523: restoring datafile 00003 to E:\ORACLE\ORADATA\TEST\USERS01.DBF
RMAN-08523: restoring datafile 00004 to E:\ORACLE\ORADATA\TEST\TEMP01.DBF
RMAN-08523: restoring datafile 00005 to E:\ORACLE\ORADATA\TEST\TOOLS01.DBF
RMAN-08523: restoring datafile 00006 to E:\ORACLE\ORADATA\TEST\INDX01.DBF
RMAN-08023: channel c1: restored backup piece 1
RMAN-08511: piece handle=E:\BACKUP\TEST\CUM_DF1_1 tag=null params=NULL
RMAN-08024: channel c1: restore complete
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: recover
RMAN-03022: compiling command: recover(1)
All RMAN experts please comment! Thank you
[Edited by newbie on 03-13-2002 at 03:06 PM]
-
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|