Home » RDBMS Server » Backup & Recovery » consistency in nomount cold backups ??
consistency in nomount cold backups ?? [message #191993] Sat, 09 September 2006 13:23 Go to next message
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 ??
Re: consistency in nomount cold backups ?? [message #191994 is a reply to message #191993] Sat, 09 September 2006 13:28 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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 ......
Re: consistency in nomount cold backups ?? [message #191997 is a reply to message #191993] Sat, 09 September 2006 13:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
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 ???
Re: consistency in nomount cold backups ?? [message #192006 is a reply to message #191993] Sat, 09 September 2006 14:19 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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.
Re: consistency in nomount cold backups ?? [message #196019 is a reply to message #191993] Tue, 03 October 2006 14:04 Go to previous message
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
Previous Topic: RMAN Question
Next Topic: Archive Log files
Goto Forum:
  


Current Time: Sat Dec 03 18:16:53 CST 2016

Total time taken to generate the page: 0.22407 seconds