Hi all! I facing following issue: here is my scenario.
I do a hot backup of DB (database opened, in archivelog mode) on Sunday, performing these operations:
I don't have RMAN catalog.
$ORACLE_HOME/bin/rman nocatalog target / log='/backup_db/log_run_ba
ckup.log' << !
RUN {
ALLOCATE CHANNEL c1 TYPE DISK;
ALLOCATE CHANNEL c2 TYPE DISK;
ALLOCATE CHANNEL c3 TYPE DISK;
ALLOCATE CHANNEL c4 TYPE DISK;
BACKUP SPFILE FORMAT '/backup_db/spfile_t%t_s%s
_p%p';
BACKUP AS COMPRESSED BACKUPSET FULL DATABASE FORMAT 'backup_db/df_t%t_s%s_p%p'
FILESPERSET = 10;
BACKUP CURRENT CONTROLFILE FORMAT '/backup_db/cf_t%t_s%s_p%p
';
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
RELEASE CHANNEL c1;
RELEASE CHANNEL c2;
RELEASE CHANNEL c3;
RELEASE CHANNEL c4;
}
Since thursday, I have some archives in default directory of archivelog.
On friday the DB was dropped.
When I restore& recoverdy DB from backup performed on Sunday, it doesn't apply archivelog generated after Sunday.
If I query v$log_history, I don't find archivelog.
Operations performed for recovery DB are:
rman target /
set DBID=<>;
restore spfile to '$ORACLE_HOME/dbs/init<SID
>.ora' from '<Spfile_backup>';
In another window I create spfile from this pfile.
Returning to RMAN window, I do:
startup force nomount;
restore controlfile from '<BACKUP_CONTROLFILE>;
startup mount;
restore database;
recover database; ------> at this point I see that it doesn't apply new archivelog after Sunday backup
recover database noredo;
alter database open resetlogs;
The DB is opened, but without archivedlog generated after backup.
What operations I perform to apply them ?
Any clues?
Thanks in advance
Start Free Trial