Home » RDBMS Server » Backup & Recovery » Which Full Backup can I most afford to delete? (11.2.0.4, SLES SP2)
Which Full Backup can I most afford to delete? [message #652646] |
Wed, 15 June 2016 08:37  |
 |
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!
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed May 28 17:05:26 CDT 2025
|