OraFAQ Forum: Backup & Recovery » Rman backup in mount stage

Home » RDBMS Server » Backup & Recovery » Rman backup in mount stage (Oracle 10.2.0.2.0 ,solaris) (

) 1 Vote

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

Rman backup in mount stage [message #397930]

Tue, 14 April 2009 10:36

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Hi,

Why is that we recover database and take whole database backup in cold backup in mount stage?

For example

rman target /
shutdown immediate;
startup mount;
backup database plus archivelog all;
alter database open;
exit

Is there any specific reason for this?

Regards,
Balaji

[Updated on: Tue, 14 April 2009 10:39]

Report message to a moderator

Re: Rman backup in mount stage [message #397934 is a reply to message #397930]

Tue, 14 April 2009 10:51

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Why is that we recover database and take whole database backup for cold backup in mount stage?
recovery and backup are different stages.
If the database is in noarchivelog mode, RMAN needs the database to be mounted.
If you are using user managed cold backups, you can just shutdown and backup.
With RMAN for consistent backup, database needs to be in mounted state as it can grab some essential information through backdoors.

Report message to a moderator

Re: Rman backup in mount stage [message #397935 is a reply to message #397934]

Tue, 14 April 2009 11:10

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Thanks for your information

Balaji

Report message to a moderator

Re: Rman backup in mount stage [message #398850 is a reply to message #397930]

Sat, 18 April 2009 08:23

haykeenzy
Messages: 1
Registered: April 2009
Location: NIGERIA

Junior Member

oracle requires a connection to an instance before any changes can be done on the database, this is 1 reason you have mount the database before you can take backup

Report message to a moderator

Re: Rman backup in mount stage [message #399230 is a reply to message #398850]

Tue, 21 April 2009 03:39

abs_amit
Messages: 59
Registered: January 2006
Location: delhi

Member

Apart from all these, RMAN reads information from Control file which is availabe only on MOUNT state.

Report message to a moderator

Previous Topic:	recover dump file
Next Topic:	Oracle DB backup/restore (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 16:58:01 CDT 2024