-
I have OPS. aix 4.3
I wnat to restore from cluster A to B. I have the backup of A. But no archivelogs.
Now I have restore to B. But it won't open irrespectively of the option I use. It call for use of backup contofile MUST BE DONE. But when you do that it calls for some checkpoint or log to be applied. The problem is I want to assume that all these achive logs are missing and thus open with resetlogs. I have used (set until scn 1635063555 this is the latest checkpoit in the controlfile that was backed up. I have even gone to earlier SCNs. In desperation I have decided to set time to 1 then 2 days earlier that the day of backup (rremmber this is whole database backup). Does this mean you cannot open a database without applying a log? This is somewhat fussy to me because if I took a bckup on jan 04 (online) it follows that all SCNS which were generated on jan 03:00:00 should be in the controlfile by now. Then i can be able to recover to say 03:23:59 and open with resetlogs 'b/c I don't have the archives'. Thsi this has been impossible. Below is an except of problem encountered.
SVRMGR> recover database until time '2002-04-10:00:00:00';
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SVRMGR> recover database until time '2002-03-10:00:00:00';
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SVRMGR> RECOVER DATABASE UNTIL CHANGE 1634289916;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SVRMGR> recover database until cancel using backup controlfile;
ORA-00279: change 1629340135 generated at 12/28/2001 17:35:18 needed for thread
1
ORA-00289: suggestion : /u02/oracle/admin/prod/arch/prod1/redo1_25867.arc
ORA-00280: change 1629340135 for thread 1 is in sequence #25867
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel;
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '/dev/rprod_0208_000'
SVRMGR>
Life is what is happening today while you were planning tomorrow.
-
Even when you do an incomplete recovery, you need to apply at least one archive log after restoring your datafile(s). This would be the archive log containing the end-of-backup marker. Without that, you can't get the database into a consistent state.
sonofsita
http://www.ordba.net
-
To do the restore and recovery, you need to be connected to the RMAN. In your case, looks like your are trying to do things through the server manager.
http://technet.oracle.com/docs/produ...pdb.htm#441628
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Yea, because RMAN does not understand USING BACKUP CONTROLFILE.
Life is what is happening today while you were planning tomorrow.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|