-
Testing Rman Backup
Im testing my Rman backup.
We do our backup with the following command:
BACKUP AS COPY DATABASE TAG = 'Full Copy 2007/03/11 19:15:02';
On another machine, im testing the recovery like the following:
rman TARGET / NOCATALOG
startup nomount;
SET DBID my_bd_id;
RESTORE CONTROLFILE FROM '/mnt/jukprod_rman/rman_backup/20070311/c-3976015942-20070311-00';
alter database mount;
RESTORE DATABASE UNTIL TIME "TO_DATE('20070311 21:35:00','YYYYMMDD HH24:MI:SS')" PREVIEW;
Problem:
Rman wants 2 months of archive logs!!
no backup of log thread 1 seq 80017 lowscn 10641963078 found to restore
To
no backup of log thread 1 seq 85592 lowscn 13248466314 found to restore
That is 5575 archive logs that Rman needs. 100 Megs in size.
so Rman needs 557 gig of archive!
Whats wrong here?
How come Rman needs all those archive?
Why would rman need archive older that the backup since we did a backup as copy?
We want full backup with not need older archive logs.
-
rman TARGET / NOCATALOG
-----------------------------
Can you try using catalog during restore ?
-
We are not using catalog for out rman backup. Everything in controlfile.
-
-
Solved everything witht the following metalink note: Note:419137.1
-
Can you post a summary of that note?