Home » RDBMS Server » Backup & Recovery » Restor database problem (by rman)
Restor database problem (by rman) [message #382914] Mon, 26 January 2009 04:54 Go to next message
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

Re: Restor database problem (by rman) [message #382916 is a reply to message #382914] Mon, 26 January 2009 05:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
RMAN does not backup the redo logs and since you removed the old redo logs, you have to open with RESETLOGS. In addition, after the RESTORE DATABASE command, you should issue a RECOVER DATABASE command.
Re: Restor database problem (by rman) [message #383385 is a reply to message #382916] Wed, 28 January 2009 11:08 Go to previous messageGo to next message
Fayyaz
Messages: 7
Registered: April 2005
Junior Member
khosravi
you posted message here also. I think it has been solved at OTN forum. please accept my solution there.

Appoo
Re: Restor database problem (by rman) [message #383390 is a reply to message #383385] Wed, 28 January 2009 11:30 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you could post the link to the OTN thread.

Regards
Michel
Previous Topic: Oracle RMAN Backup API
Next Topic: Data backup ideas needed
Goto Forum:
  


Current Time: Sat Dec 10 05:18:35 CST 2016

Total time taken to generate the page: 0.04652 seconds