| need help with archivelogs [message #498937] |
Sat, 12 March 2011 01:02  |
ateeqrahman786
Messages: 52
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 #498944 is a reply to message #498940] |
Sat, 12 March 2011 01:32  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
John Watson
Messages: 8960
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 |
ateeqrahman786
Messages: 52
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 |
|
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
