I am using Oracle10g (10.2.0.1) in Redhat Ent Linux 5.0 . Recently I want to make another server using production rman full backup . so that , First,
I take a full backup of the production server using below script :
-------
$ORACLE_HOME/bin/rman target sys/pwd log=/rman/backrmanfull/rman_full_$Date.log<< !
run{
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK format '/rman/backrmanfull/$Date/df_%T_%s_%p';
BACKUP CHECK LOGICAL AS COMPRESSED BACKUPSET database TAG = 'Full Backup';
backup format '/rman/backrmanfull/$Date/controlfile_$Date.ctlbk'
(current controlfile);
backup format '/rman/backrmanfull/$Date/spfile_$Date.spbak'
(spfile);
backup archivelog all;
#delete noprompt archivelog until time 'sysdate -1';
#delete noprompt archivelog all;
}
(Here I mention that , oracle block change tracking is enable in our production database and also I take rman compressed backup always.)
---------
Now I transfer this full backup to the different server end . and when I recover database , it successfully recover the database . I mention some output below :
---
channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/PBLPRIM/BACKOFF_USERAUDIT_LOG
channel ORA_DISK_1: reading from backup piece /rman/backrman/20Sep2013.05.00AM/df_20130920_11077_1
channel ORA_DISK_1: piece handle=/rman/backrman/20Sep2013.05.00AM/df_20130920_11077_1 tag=FULL COMPRESSED BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 03:12:35
Finished restore at 23-SEP-13
----
But when I make recover database then I got the below error :
----
RMAN> recover database;
Starting recover at 26-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
starting media recovery
unable to find archived log
archived log thread=1 sequence=29063
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/26/2013 09:34:45
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 29063 and starting SCN of 7710815235
----
Later on , I got a solution from "RMAN-06054: media recovery requesting unknown archived log" and
I run the "recover database noredo" , output below :
RMAN> recover database noredo;
Starting recover at 26-SEP-13
using channel ORA_DISK_1
Finished recover at 26-SEP-13
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 09/26/2013 09:59:22
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/app/oracle/oradata/PBLPRIM/system01.dbf'
now I got error when I open the database .
Now anybody plz tell me where is the problem and how can I resolve it ?