Home » RDBMS Server » Backup & Recovery » need help with archivelogs (8.1.7.4, win 2000 server)
need help with archivelogs [message #498937] Sat, 12 March 2011 01:02 Go to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
Hi,

I have a doubt in RMAN. The scenario is:
We take online backup on all days and offline backup on Sunday only. My question is do i need to copy the archives also in offline backup?

What happens when i shutdown the database (the database is in archivelog mode) and alter the database to be in noarchivelog and open the database to do offline backup.

Please help me.

Thanks,
Re: need help with archivelogs [message #498938 is a reply to message #498937] Sat, 12 March 2011 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
My question is do i need to copy the archives also in offline backup?

1/ Which archived logs are you thinking of?
2/ It depends on your restore/recover policy.

Quote:
open the database to do offline backup.

You cannot open a database to do an offline backup.
By definition, an offline backup is done when the database is not open.

And my question is: why do you do an offline backup anyway?

Regards
Michel
Re: need help with archivelogs [message #498940 is a reply to message #498938] Sat, 12 March 2011 01:19 Go to previous messageGo to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
sorry, my question was,are the archives useful when we do offline backup?
Re: need help with archivelogs [message #498944 is a reply to message #498940] Sat, 12 March 2011 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still the same questions:
1/ Which archived logs are you thinking of? Before or after offline backup?
2/ It depends on your restore/recover policy. Tell us which service do you guarantee to your client.

And my question is: why do you do an offline backup anyway?

Regards
Michel

[Updated on: Sat, 12 March 2011 01:33]

Report message to a moderator

Re: need help with archivelogs [message #498946 is a reply to message #498937] Sat, 12 March 2011 01:49 Go to previous messageGo to next message
John Watson
Messages: 4569
Registered: January 2010
Location: Global Village
Senior Member
Quote:
alter the database to be in noarchivelog
This is not right. In fact, it is potentially disastrous. If your client demands on offline backup (and, as Michel says, you should ask them about that) you must do it in archivelog mode, with the archivelogs.
Re: need help with archivelogs [message #498947 is a reply to message #498944] Sat, 12 March 2011 02:00 Go to previous messageGo to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
Suppose my database is in archivelog mode. For some reason the client needs offline backup. i would do the following steps:
1) shutdown the database and set the database in noarchivelog mode.
2)take offline backup and restart the server in archivelog mode again.

In the above steps, i would like to know if there will be any problem since we are not copying archives (the resolog archives which are stored with this parameter 'archive_log_dest=e:\archives') generated when we were in archivelog mode.


Hope you got my question

[Updated on: Sat, 12 March 2011 02:02]

Report message to a moderator

Re: need help with archivelogs [message #498954 is a reply to message #498947] Sat, 12 March 2011 03:06 Go to previous message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
For some reason the client needs offline backup

Wrong! A client NEVER needs this. A client needs you are able to restore and recover his database, how you odo it he does not care.

Quote:
would do the following steps:
1) shutdown the database and set the database in noarchivelog mode.
2)take offline backup and restart the server in archivelog mode again.

And your backup is useless (with or without archived logs) to recover. You will be able to ONLY restore at the time of the backup and NOT to recover.

Regards
Michel


[Updated on: Sat, 12 March 2011 03:06]

Report message to a moderator

Previous Topic: Archived Log in only one folder
Next Topic: Rman Cloning - what am i doing wrong?
Goto Forum:
  


Current Time: Sat Sep 20 15:46:21 CDT 2014

Total time taken to generate the page: 0.10053 seconds