Home » RDBMS Server » Backup & Recovery » bakup
bakup [message #328433] Fri, 20 June 2008 03:16 Go to next message
narmadakumari
Messages: 3
Registered: June 2008
Location: hyd
Junior Member
A database is running in NOARCHIVELOG mode then which type of backups you can take?
Re: bakup [message #328436 is a reply to message #328433] Fri, 20 June 2008 03:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Cold backup.

Regards
Michel
Re: bakup [message #329801 is a reply to message #328433] Thu, 26 June 2008 10:39 Go to previous messageGo to next message
hhelgen
Messages: 12
Registered: April 2007
Location: Duluth MN
Junior Member
If you are using RMAN, possible code for a cold backup of noarchivelog is:

STARTUP FORCE DBA;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;

BACKUP DATABASE FILESPERSET 4;
ALTER DATABASE OPEN;


Notice that the extra startup force ensures that the shutdown is consistent.
Re: bakup [message #332335 is a reply to message #328433] Tue, 08 July 2008 04:11 Go to previous messageGo to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

cold backup
Re: bakup [message #332339 is a reply to message #332335] Tue, 08 July 2008 04:17 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ziauldba wrote on Tue, 08 July 2008 11:11
cold backup

Nice to see you want to participate to this forum but why repeating an answer 3 weeks later?

Regards
Michel
Previous Topic: how to recover data after it is deleted
Next Topic: Overriding an RMAn backup set/pieces
Goto Forum:
  


Current Time: Wed Dec 07 20:39:39 CST 2016

Total time taken to generate the page: 0.08787 seconds