Home » RDBMS Server » Backup & Recovery » oracle 10g (RMAN)
oracle 10g (RMAN) [message #267097] Wed, 12 September 2007 08:22 Go to next message
gunsbong
Messages: 44
Registered: May 2007
Member
hi to everybody!
our company is having 2 unix server,1 for production and the other is for standby.this 2 server has exactly the same setup and configuration.production server has daily backup which is copied to the standby.now,when i use RMAN RESTORE to restore the datafiles in standby, several errors arise like system01.dbf etc...and in the end i could not start the database(standby)...
could anyone help me by giving an easy step by step procedure in accomplishing this goal. Embarassed
Re: oracle 10g (RMAN) [message #267109 is a reply to message #267097] Wed, 12 September 2007 08:58 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
There is no easy step by step procedure.

The start would be :

Step 1 : Actual READ the EXACT error messages.

Step 2 : Search for them on Google, Metalink or here.





Re: oracle 10g (RMAN) [message #267146 is a reply to message #267109] Wed, 12 September 2007 10:23 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Why not DATAGUARD Instead of restoring RMAN backup daily?
Re: oracle 10g (RMAN) [message #267440 is a reply to message #267097] Thu, 13 September 2007 05:11 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
SQL> startup
ORACLE instance started.

Total System Global Area 8002732032 bytes
Fixed Size 2056632 bytes
Variable Size 838864456 bytes
Database Buffers 7147094016 bytes
Redo Buffers 14716928 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

but before this, when im still using RMAN restore i encountered ORA-01180 and ORA-01110 Embarassed
Re: oracle 10g (RMAN) [message #267459 is a reply to message #267440] Thu, 13 September 2007 06:24 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
You can configure a standby database.
Re: oracle 10g (RMAN) [message #267461 is a reply to message #267440] Thu, 13 September 2007 06:25 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-01180: can not create datafile 1
 *Cause:  Attempting to create datafile 1 using ALTER DATABASE CREATE
          DATAFILE.
 *Action: Recover file from a backup or recreate database.

Of course you realize that giving us partial information can only lead to no solution (unless you are very lucky).
You have to post ALL what happened and what you did.

Regards
Michel
Previous Topic: Need Advice on Backup strategy
Next Topic: master db in archive mode and slaves not
Goto Forum:
  


Current Time: Tue Nov 26 09:42:52 CST 2024