OraFAQ Forum: Backup & Recovery » consistency in nomount cold backups ??

Home » RDBMS Server » Backup & Recovery » consistency in nomount cold backups ??

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

consistency in nomount cold backups ?? [message #191993]

Sat, 09 September 2006 13:23

tridentadm
Messages: 142
Registered: March 2006

Senior Member

is it possible to do backups (ie use the copy/cp command to backup files)
when the database is in nomount stage;

ie.
SQL> startup nomount;
SQL> !cp /oracle/system01.dbf /backup/system01.dbf
SQL>

and is the backup consistent ??

Report message to a moderator

Re: consistency in nomount cold backups ?? [message #191994 is a reply to message #191993]

Sat, 09 September 2006 13:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>and is the backup consistent ??
It depends.
If you really want consistent cold backup, do:
SQL> SHUTDOWN IMMEDIATE
SQL> EXIT
cp ......

Report message to a moderator

Re: consistency in nomount cold backups ?? [message #191997 is a reply to message #191993]

Sat, 09 September 2006 13:50

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

Senior Member
Account Moderator

If you can do this
>> SQL> startup nomount;
You can certainly afford to do this and save yourself from some surprises.

quoting anacedent

Quote:

If you really want consistent cold backup, do:
SQL> SHUTDOWN IMMEDIATE
SQL> EXIT
cp ......

[Updated on: Sat, 09 September 2006 13:51]

Report message to a moderator

Re: consistency in nomount cold backups ?? [message #191999 is a reply to message #191997]

Sat, 09 September 2006 13:58

tridentadm
Messages: 142
Registered: March 2006

Senior Member

Mahesh Rajendran wrote on Sun, 10 September 2006 00:20

If you can do this
>> SQL> startup nomount;
You can certainly afford to do this and save yourself from some surprises.

whats the surprise ???

Report message to a moderator

Re: consistency in nomount cold backups ?? [message #192006 is a reply to message #191993]

Sat, 09 September 2006 14:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>whats the surprise ???
Would it surprise you to restore the DB & it refuses to open because it is not in a consistent state?
That might happen if you follow the steps in the original post.

Report message to a moderator

Re: consistency in nomount cold backups ?? [message #196019 is a reply to message #191993]

Tue, 03 October 2006 14:04

parthokonar
Messages: 17
Registered: September 2006
Location: india

Junior Member

Certainly it can be done as in nomount state control files are not open, it is better to go for shutdown immediate or transactional

Report message to a moderator

Previous Topic:	RMAN Question
Next Topic:	Archive Log files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 12:24:33 CST 2024