Hi Guys ,
I am trying to restore a database to new Server , but I have Started getting Error Recently
My Backup Script:
run {
allocate channel ch00 type disk format '/orabackup/RMANBKP/SIMUAT/SIMUAT_%T_%U';
allocate channel ch01 type disk format '/orabackup/RMANBKP/SIMUAT/SIMUAT_%T_%U';
allocate channel ch02 type disk format '/orabackup/RMANBKP/SIMUAT/SIMUAT_%T_%U';
allocate channel ch03 type disk format '/orabackup/RMANBKP/SIMUAT/SIMUAT_%T_%U';
allocate channel ch04 type disk format '/orabackup/RMANBKP/SIMUAT/SIMUAT_%T_%U';
setlimit channel ch00 kbytes 2097150;
setlimit channel ch01 kbytes 2097150;
setlimit channel ch02 kbytes 2097150;
setlimit channel ch03 kbytes 2097150;
setlimit channel ch04 kbytes 2097150;
backup incremental level 0 database plus archivelog ;
backup as copy current controlfile format '/orabackup/RMANBKP/SIMUAT/control__%T_%U.ctl';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
RELEASE CHANNEL ch04;
RELEASE CHANNEL ch05;
}
While Restoring on different Server I am following procedure
1: Opening Clone Database in Nomount state (with Pfile)
2: Recovering controlfile from backup
3: Mouting Clone Database
4: Restoring Datafiles with follwing script
run {
catalog start with '/orabackup/RMANBKP/SIMPRD/RMAN_16_Jul_2014';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;
allocate channel ch00 type disk format '/oradata/SIMPRD/SIMPRD_%T_%U';
allocate channel ch01 type disk format '/oradata/SIMPRD/SIMPRD_%T_%U';
restore database;
switch datafile all;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
5: BAcking up controlfile and Recreaing with resetlogs and NOArchivelog mode
6:now Running below command to open database .
run {
recover database ;
alter database open resetlogs;
}
Now Issue is
1: Open database failing with below Error
SQL> run {
recover database ;
alter database open resetlogs
}
Starting recover at 16-JUL-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=193 device type=DISK
starting media recovery
RMAN-08187: WARNING: media recovery until SCN 6020263420798 complete
Finished recover at 16-JUL-14
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oradata/SIMPRD/system01.dbf'
2: WHy Redo logs are not getting created ,Even after recreating controlfile ?
3: How to create REDO logs if they are not created while recovery
4: Above Error (ORA-01152:ORA-01110) I am even getting while Cloning Database with RMAN clone method .
Please suggest , What i am doing wrong?
Regards,
Manish