| Cannot restore from hot full backup(ORA-01152 RMAN-06053) [message #399508] |
Wed, 22 April 2009 11:40  |
i1888
Messages: 7
Registered: April 2009
|
Junior Member |
|
|
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 ~~~~
|
|
|
|
| Re: Cannot restore from hot full backup(ORA-01152 RMAN-06053) [message #399509 is a reply to message #399508] |
Wed, 22 April 2009 11:49  |
i1888
Messages: 7
Registered: April 2009
|
Junior Member |
|
|
further more,i run "list backup of archivelog"：
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
57403 784.50M SBT_TAPE 00:00:58 16-APR-09
BP Key: 57406 Status: AVAILABLE Compressed: NO Tag: TAG20090416T210415
Handle: al_4241_1_684363858 Media:
List of Archived Logs in backup set 57403
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 4340 150132389 16-APR-09 150158118 16-APR-09
1 4341 150158118 16-APR-09 150181582 16-APR-09
1 4342 150181582 16-APR-09 150211583 16-APR-09
1 4343 150211583 16-APR-09 150232988 16-APR-09
1 4344 150232988 16-APR-09 150269585 16-APR-09
1 4345 150269585 16-APR-09 150296436 16-APR-09
1 4346 150296436 16-APR-09 150326478 16-APR-09
1 4347 150326478 16-APR-09 150349458 16-APR-09
1 4348 150349458 16-APR-09 150363355 16-APR-09
1 4349 150363355 16-APR-09 150363386 16-APR-09
4346 is available.
what should i do???
Thanks a lot.
|
|
|
|
| Re: Cannot restore from hot full backup(ORA-01152 RMAN-06053) [message #399511 is a reply to message #399508] |
Wed, 22 April 2009 11:54 |
i1888
Messages: 7
Registered: April 2009
|
Junior Member |
|
|
4346 is archived last Thu, 2009-4-16.
I suddenly remember that, i made a successful restore that day(recover database until '' ; alter database open.)
and later, i made a command "backup database datafile 2" on RMAN to test the network to Veritas.
After that day, i alwasy met this problem, never recover successfully.
Could me give me some suggestions?
Thanks a lot
|
|
|
|
| Re: Cannot restore from hot full backup(ORA-01152 RMAN-06053) [message #399513 is a reply to message #399508] |
Wed, 22 April 2009 12:27 |
i1888
Messages: 7
Registered: April 2009
|
Junior Member |
|
|
I tried find the archivelog back,
First, check the archivelog if is available:
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
57403 784.50M SBT_TAPE 00:00:58 16-APR-09
BP Key: 57406 Status: AVAILABLE Compressed: NO Tag: TAG20090416T210415
Handle: al_4241_1_684363858 Media:
List of Archived Logs in backup set 57403
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 4340 150132389 16-APR-09 150158118 16-APR-09
1 4341 150158118 16-APR-09 150181582 16-APR-09
1 4342 150181582 16-APR-09 150211583 16-APR-09
1 4343 150211583 16-APR-09 150232988 16-APR-09
1 4344 150232988 16-APR-09 150269585 16-APR-09
1 4345 150269585 16-APR-09 150296436 16-APR-09
1 4346 150296436 16-APR-09 150326478 16-APR-09
1 4347 150326478 16-APR-09 150349458 16-APR-09
1 4348 150349458 16-APR-09 150363355 16-APR-09
1 4349 150363355 16-APR-09 150363386 16-APR-09
then find it back;
RMAN> run {
2> allocate channel c1 type sbt;
3> send 'NB_ORA_CLIENT=db';
4> restore archivelog from logseq 4340 until logseq 4352;
5> }
But still failed:
RMAN> run {
2> set until time "to_date('2009/04/22 19:00:00','yyyy/mm/dd hh24:mi:ss')";
3> allocate channel c1 type sbt;
4> send 'NB_ORA_CLIENT=db';
recover database;
5> 6> }
executing command: SET until clause
allocated channel: c1
channel c1: sid=322 devtype=SBT_TAPE
channel c1: VERITAS NetBackup for Oracle - Release 5.1 (2004043014)
sent command to channel: c1
Starting recover at 23-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/23/2009 01:22:11
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
|
|
|
|
|
|
|
|
|
|
| Re: Cannot restore from hot full backup(ORA-01152 RMAN-06053) [message #399546 is a reply to message #399508] |
Wed, 22 April 2009 21:27 |
i1888
Messages: 7
Registered: April 2009
|
Junior Member |
|
|
| i1888 wrote on Wed, 22 April 2009 11:40 | 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
Oracle 10.2.0.4.0
AIX 5.3
b.test machine
Oracle 10.2.0.4.0
AIX 5.3
c.catalog machine
Oracle 10.2.0.1.0
Windows 2003
d. Veritas machine
windows 2003
veritas 5.1
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 ~~~~
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
