OraFAQ Forum: Backup & Recovery

Fri, 20 June 2008 03:16

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?

Fri, 20 June 2008 03:22

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

Senior Member
Account Moderator

Cold backup.

Regards
Michel

Thu, 26 June 2008 10:39

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.

Tue, 08 July 2008 04:11

ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh

Member

cold backup

Tue, 08 July 2008 04:17

Michel Cadot
Messages: 68647
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: Mon Apr 29 10:02:40 CDT 2024