Home » RDBMS Server » Backup & Recovery » Cannot restore from hot full backup(ORA-01152 RMAN-06053) (Oracle,10.2.0.4.0,AIX 5.3)
Cannot restore from hot full backup(ORA-01152 RMAN-06053) [message #399508] Wed, 22 April 2009 11:40 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #399515 is a reply to message #399508] Wed, 22 April 2009 12:29 Go to previous messageGo to next message
i1888
Messages: 7
Registered: April 2009
Junior Member
So I wonder why since i get a hot full backup just a few minutes earlier, and restore need a archivelog long time ago?

I am confused....
Re: Cannot restore from hot full backup(ORA-01152 RMAN-06053) [message #399543 is a reply to message #399508] Wed, 22 April 2009 20:40 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.

It would also help if you actually posted the results of hot backup, because some sort of disconnect apparently exists.
Re: Cannot restore from hot full backup(ORA-01152 RMAN-06053) [message #399545 is a reply to message #399508] Wed, 22 April 2009 21:02 Go to previous messageGo to next message
i1888
Messages: 7
Registered: April 2009
Junior Member
I upload the log.
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 Go to previous message
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 ~~~~




Previous Topic: reduce rman backup size
Next Topic: Backup using schedular using a procedure
Goto Forum:
  


Current Time: Sat Dec 03 04:08:57 CST 2016

Total time taken to generate the page: 0.10788 seconds