| Restor database problem (by rman) [message #382914] |
Mon, 26 January 2009 04:54  |
khosravi
Messages: 68
Registered: April 2006
|
Member |
|
|
Hello
I backed up my database by this commend while database was mount
RMAN>backup incremental level 0 database plus archivelog delete all input;
RMAN> delete force noprompt obsolete;
then I formated my disk and I Installed new Oracle software
when i want restore the backup i recieve this error
**************************************************************************************
RMAN>list backup
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -----------------
223 Incr 0 2.53G DISK 00:16:36 09/01/26 01:16:15
BP Key: 223 Status: AVAILABLE Compressed: YES Tag: TAG20090126T005939
Piece Name: /rep1Backup/rep120090126_ts_677120379_REP1_241.bk
List of Datafiles in backup set 223
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ----------------- ----
1 0 Incr 266945118 09/01/26 00:45:28 /u01/app/oracle/oradata/rep1/system01.dbf
2 0 Incr 266945118 09/01/26 00:45:28 /u01/app/oracle/oradata/rep1/undotbs01.dbf
3 0 Incr 266945118 09/01/26 00:45:28 /u01/app/oracle/oradata/rep1/sysaux01.dbf
4 0 Incr 266945118 09/01/26 00:45:28 /u01/app/oracle/oradata/rep1/users01.dbf
5 0 Incr 266945118 09/01/26 00:45:28 /oracle2/rep1_users02.dbf
6 0 Incr 266945118 09/01/26 00:45:28 /u01/app/oracle/oradata/rep1/rep1_users03.dbf
7 0 Incr 266945118 09/01/26 00:45:28 /u01/app/oracle/oradata/rep1/system02.dbf
8 0 Incr 266945118 09/01/26 00:45:28 /u01/app/oracle/oradata/rep1/sysaux02.dbf
9 0 Incr 266945118 09/01/26 00:45:28 /oracle1/rep1_users04.dbf
10 0 Incr 266945118 09/01/26 00:45:28 /u01/app/oracle/oradata/rep1/undotbs02.dbf
-- this is the latest backup
RMAN> restore database;
Starting restore at 09/01/27 02:03:21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/rep1/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/rep1/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/rep1/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/rep1/users01.dbf
restoring datafile 00005 to /oracle2/rep1_users02.dbf
restoring datafile 00006 to /u01/app/oracle/oradata/rep1/rep1_users03.dbf
restoring datafile 00007 to /u01/app/oracle/oradata/rep1/system02.dbf
restoring datafile 00008 to /u01/app/oracle/oradata/rep1/sysaux02.dbf
restoring datafile 00009 to /oracle1/rep1_users04.dbf
restoring datafile 00010 to /u01/app/oracle/oradata/rep1/undotbs02.dbf
channel ORA_DISK_1: reading from backup piece /rep1Backup/rep120090126_ts_677120379_REP1_241.bk
channel ORA_DISK_1: restored backup piece 1
piece handle=/rep1Backup/rep120090126_ts_677120379_REP1_241.bk tag=TAG20090126T005939
channel ORA_DISK_1: restore complete, elapsed time: 00:17:05
Finished restore at 09/01/27 02:20:27
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 01/27/2009 02:20:41
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 01/27/2009 02:20:58
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/app/oracle/oradata/rep1/system01.dbf'
**************************************************************************************
because I backed up database while it was mount i expect that "alter database open" open the database
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
