Databases Reference
In-Depth Information
SQL> select min(first_nologged_scn_) from v$datafile where first_nologged_scn > 0;
MIN(FIRST_NONLOGGED_SCN)
------------------------
223948
If you are using a recovery catalog, RMAN will automatically set the path names for all data files in the
standby control file. If not, you must execute the RMAN
set newname
command to set the data file names.
You must be connected to the recovery catalog during the execution of the
restore standby controlfile
command, for that command to work. The alternative is to execute the
restore standby controlfile from
'<control_file backup filename>'
command.
Configuring Archive Log Deletion Policies on the Primary
and Standby Databases
Problem
You want to correctly configure the deletion policy for archived redo logs on a standby database.
Solution
You can specify automatic archived redo log deletion or you can manually delete the logs yourself. We explain both
strategies here.
Configuring Automatic Deletion of Archived Logs
Execute an RMAN
configure
command to enable automatic deletion of those archived logs on the primary database
that have been applied to a standby destination or destinations. Here's an example:
RMAN> configure archivelog deletion policy to applied on standby;
You must issue this command at the primary database and after connecting to each of the other standby
databases and the recovery catalog.
Manually Deleting Archived Redo Logs
You can delete archived redo logs that you've already backed up, with the
delete archivelog
command. The
following command, for example, will delete all the archived logs generated prior to 3 days ago and have at least 2
copies on tape.
RMAN> delete archivelog all backed up 2 times to sbt
completed before 'sysdate -3';
How It Works
On the primary database, the first command shown in the solution will enable the automatic deletion of archived logs
that have already been applied to remote standby destinations. This configuration also requires that you set at least
one remote destination to mandatory.
