-
Cannot restore from hot full backup(ORA-01152 RMAN-06053)
Hi all,
I want to make a recovery practice before we move to another building,but i met a problem which i canot resolve:
a.production machine
b.test machine
c.catalog machine
1. I did a hot backup via Veritas, and it was finished at 22-APR 12:45
2. I have a test machine which i have configure all the enviroment already(including spfile,tnsnames.ora .etc..)
3. Catalog is on the third machine.
4. i run rman on the test machine(rman target / catalog rman/rman@aaa)
5. RMAN>startup nomount
6. run {
allocate channel c1 type sbt;
send 'NB_ORA_CLIENT=db';
restore controlfile;
}
7. RMAN>alter database mount;
8. list backup of controlfile;
List of Backup Sets
===================
............
............
............
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
74053 Incr 0 5.75M SBT_TAPE 00:01:38 22-APR-09
BP Key: 74063 Status: AVAILABLE Compressed: NO Tag: TAG20090422T182046
Handle: full_FIMASYS_4400_1_684873116.bak Media: 0050L2
Control File Included: Ckp SCN: 153914435 Ckp time: 22-APR-09
9. host;sqlplus ...
10. SQL> select controlfile_change# from v$database;
CONTROLFILE_CHANGE#
-------------------
153914435
11.exit to RMAN
12.RMAN> run {
2> set until time "to_date('2009/04/22 13:00','yyyy/mm/dd hh24:mi:ss')";
3> allocate channel c1 type sbt;
4> send 'NB_ORA_CLIENT=db';
5> restore database;
6> recover database;
7> }
Finished restore at 22-APR-09
Starting recover at 22-APR-09
starting media recovery
Oracle Error:
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: '/oradata/FIMASYS10G/undotbs1.dbf'
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/22/2009 20:02:50
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 4346 lowscn 150296436 found to restore
13. Go to Sqlplus to check the latest v$log
SQL> select thread#,sequence# from v$log;
THREAD# SEQUENCE#
---------- ----------
1 4474
1 4472
1 4473
SQL> select controlfile_change# from v$database;
CONTROLFILE_CHANGE#
-------------------
153914435
SQL> select archivelog_change# from v$database;
ARCHIVELOG_CHANGE#
------------------
153912062
SQL> select checkpoint_change# from v$datafile;
CHECKPOINT_CHANGE#
------------------
153913134
153913863
153913659
153913659
153913863
153913134
153913659
153913133
153913133
153913133
153913863
CHECKPOINT_CHANGE#
------------------
153913134
153913659
153913133
153913863
153913134
153913659
153913133
18 rows selected.
SQL> select * from v$backup
2 ;
FILE# STATUS CHANGE# TIME
---------- ------------------------------------ ---------- ------------
1 NOT ACTIVE 0
2 NOT ACTIVE 0
3 NOT ACTIVE 0
4 NOT ACTIVE 0
5 NOT ACTIVE 0
6 NOT ACTIVE 0
7 NOT ACTIVE 0
8 NOT ACTIVE 0
9 NOT ACTIVE 0
10 NOT ACTIVE 0
11 NOT ACTIVE 0
FILE# STATUS CHANGE# TIME
---------- ------------------------------------ ---------- ------------
12 NOT ACTIVE 0
13 NOT ACTIVE 0
14 NOT ACTIVE 0
15 NOT ACTIVE 0
16 NOT ACTIVE 0
17 NOT ACTIVE 0
18 NOT ACTIVE 0
18 rows selected.
I firstly thought that i may delete the archlog accidently, so i go to rman and run
"crosscheck archivelog all",then made a hot full backup again, then make a restore exercise, but failed again.
So, could anyone give me some suggestions ??
Thanks a lot ~~~~
-
Pit
You may need to do Point In Time recovery.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
...
RMAN-03002: failure of recover command at 04/22/2009 20:02:50
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 4346 lowscn 150296436 found to restore
...
SQL> select thread#,sequence# from v$log;
THREAD# SEQUENCE#
---------- ----------
1 4474
1 4472
1 4473
You don't have archive for log seq 4346; you need to do a PITR. You said you did a full hot backup but couldn't restore with the same, is your db in archivelog mode?
-
It was kinda strange...
It works if i use "recover database ... " in sqlplus but not rman....
Tags for this Thread
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
|