Which Full Backup can I most afford to delete? [message #652646] |
Wed, 15 June 2016 08:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/82920145e40e0c65c671e4d0b8212ab7?s=64&d=mm&r=g) |
juniordbanewbie
Messages: 250 Registered: April 2014
|
Senior Member |
|
|
Dear all,
currently my backup disk is only 490G
my current one full backup is about 130G
in simple maths 490G/130G only 3 full backup
DB still in non archive log
based on http://docs.oracle.com/cd/E11882_01/server.112/e25494/archredo.htm#ADMIN11335
Shut down the database instance.
SHUTDOWN IMMEDIATE
An open database must first be closed and any associated instances shut down before you can switch the database archiving mode. You cannot change the mode from ARCHIVELOG to NOARCHIVELOG if any data files need media recovery.
Back up the database.
Before making any major change to a database, always back up the database to protect against any problems. This will be your final backup of the database in NOARCHIVELOG mode and can be used if something goes wrong during the change to ARCHIVELOG mode. See Oracle Database Backup and Recovery User's Guide for information about taking database backups.
Edit the initialization parameter file to include the initialization parameters that specify the destinations for the archived redo log files (see "Setting Initialization Parameters for Archive Destinations").
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
Back up the database.
=>you need to do two full backup one in non archive mode and one in full backup
after I switch to archivelog, and do a backup, I need to upgrade to 11.2.0.4
after the upgrade I need to do the backup again making it 3 full backups,
the disk itself will also contains archivelog, which may mean in worst case scenario I may run out of disk space when backing the db after upgrade, although I do not really anticipate it.
which backup can I really afford to delete?
thanks in advance!
|
|
|
|
|
Re: Which Full Backup can I most afford to delete? [message #652652 is a reply to message #652650] |
Wed, 15 June 2016 09:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8964 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
This is really very simple. To upgrade a database takes about 40 mins, depending on your environment. All you have to do is boot everybody off, do an offline backup, upgrade, convert to archivelog mode, do another backup, and open the database. If you are not confident in your ability to this rather simple task, you could consider hiring a consultant to do it for you. It won't take him very long.
|
|
|
|
|
|