Advertisement

11.06.2008 at 01:44AM PST, ID: 23880878 | Points: 500
[x]
Attachment Details

Backup and restore problem using oracle 10.2.0.1

Asked by hanoirules in Oracle 10.x

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_backup.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 advanceStart Free Trial
 
 
[+][-]11.06.2008 at 03:43AM PST, ID: 22893898

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628