| Why should must db be open in archivelog before rebooting and doing a backup [message #652637] |
Wed, 15 June 2016 05:31  |
 |
juniordbanewbie
Messages: 250
Registered: April 2014
|
Senior Member |
|
|
Dear all,
http://docs.oracle.com/cd/E11882_01/server.112/e25494/archredo.htm#ADMIN11335
Quote:
Start a new instance and mount, but do not open, the database.
STARTUP MOUNT
To enable or disable archiving, the database must be mounted but not open.
Change the database archiving mode. Then open the database for normal operations.
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN; =>why must we open the database, reboot db again and do backup, shouldn't we just do the backup right after switching to archivelog?
Shut down the database.
SHUTDOWN IMMEDIATE
Back up the database.
why must we open the database, reboot db again and do backup, shouldn't we just do the backup right after switching to archivelog?
many thanks in advance
[Updated on: Wed, 15 June 2016 05:33] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Why should must db be open in archivelog before rebooting and doing a backup [message #652645 is a reply to message #652640] |
Wed, 15 June 2016 08:25  |
|
juniordbanewbie
Messages: 250
Registered: April 2014
|
Senior Member |
|
|
Dear Ed,
what I mean is
originally it is like this
Quote:
Start a new instance and mount, but do not open, the database.
STARTUP MOUNT
To enable or disable archiving, the database must be mounted but not open.
Change the database archiving mode. Then open the database for normal operations.
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
Shut down the database.
SHUTDOWN IMMEDIATE=>why reboot
Back up the database.=>we can do a online backup here, meaning db can be open
shouldn't we do the following:
Start a new instance and mount, but do not open, the database.
STARTUP MOUNT
To enable or disable archiving, the database must be mounted but not open.
Change the database archiving mode.
ALTER DATABASE ARCHIVELOG;
-->backup database before opening the database
->shouldn't we backup the database while database is mounted and in archivelog, why must database be rebounded again and backup again.
John I agree with you that we need to backup the database offline while it is still in non archive mode.
thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
