OraFAQ Forum: Backup & Recovery » oracle 10g (RMAN)

Home » RDBMS Server » Backup & Recovery » oracle 10g (RMAN)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle 10g (RMAN) [message #267097]

Wed, 12 September 2007 08:22

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

Report message to a moderator

Re: oracle 10g (RMAN) [message #267109 is a reply to message #267097]

Wed, 12 September 2007 08:58

ThomasG
Messages: 3211
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.

Report message to a moderator

Re: oracle 10g (RMAN) [message #267146 is a reply to message #267109]

Wed, 12 September 2007 10:23

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Why not DATAGUARD Instead of restoring RMAN backup daily?

Report message to a moderator

Re: oracle 10g (RMAN) [message #267440 is a reply to message #267097]

Thu, 13 September 2007 05:11

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

Report message to a moderator

Re: oracle 10g (RMAN) [message #267459 is a reply to message #267440]

Thu, 13 September 2007 06:24

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

You can configure a standby database.

Report message to a moderator

Re: oracle 10g (RMAN) [message #267461 is a reply to message #267440]

Thu, 13 September 2007 06:25

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 16:00:54 CDT 2024