Home » RDBMS Server » Backup & Recovery » Issue with Oracle 8i recovery
Issue with Oracle 8i recovery [message #424925] Tue, 06 October 2009 08:55 Go to next message
ganeshtambat123
Messages: 3
Registered: October 2009
Junior Member
I am using 8i (8.1.7) on windows 2k SP4 with no recovery catalog. I am
facing issues in recovery from control file backups. I am trying to do
redirected restore from Machine A to Machine B. On Machine B I have
prepared the instance with the same name and DB ID.

I have three backups and I can restore only through the first (oldest)
backup. Please see below the procedure I am following to restore:
(Followed the procedure listed on Oracle site in section "To restore from HOST_A to HOST_B without a recovery
catalog:")

- Copy the control files to machine B

- Get the SCN by executing the query:
****
SQL> SELECT min(scn)
2 FROM (SELECT max(next_change#) scn
3 FROM v$archived_log
4 GROUP BY thread#);

MIN(SCN)
----------
362799
****

- Run following RMAN script
****
RUN {
ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE';

RESTORE DATABASE UNTIL SCN 362799;

RECOVER DATABASE UNTIL SCN 362799;

RELEASE CHANNEL ch0;
alter database open resetlogs;
}
****

This works correctly for the first backup. And I can get the instance
up and running. Please note the output of "list backup" at this point
of time below: Output shows the maximum SCN is 362797.
****
RMAN> list backup;

RMAN-03022: compiling command: list

List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ----------
----------------------
1 1 698720723 0 698720644 1 28-SEP-09

List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ----------------------
------------------------
1 1 1 AVAILABLE 28-SEP-09 BE_01kqb8c4_1_1

List of Datafiles Included
File Name LV Type Ckp SCN Ckp
Time
---- ------------------------------------- -- ---- ----------
-------------
1 C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF 0 Full 362797 28-
SEP-09
2 C:\ORACLE\ORADATA\ORCL\RBS01.DBF 0 Full 362797 28-
SEP-09
3 C:\ORACLE\ORADATA\ORCL\USERS01.DBF 0 Full 362797 28-
SEP-09
4 C:\ORACLE\ORADATA\ORCL\TEMP01.DBF 0 Full 362797 28-
SEP-09
5 C:\ORACLE\ORADATA\ORCL\TOOLS01.DBF 0 Full 362797 28-
SEP-09
6 C:\ORACLE\ORADATA\ORCL\INDX01.DBF 0 Full 362797 28-
SEP-09
7 C:\ORACLE\ORADATA\ORCL\DR01.DBF 0 Full 362797 28-
SEP-09
8 C:\ORACLE\ORADATA\ORCL\TEST01.DBF 0 Full 362797 28-
SEP-09
****

Now the problem is if I restore control files from the second or third
backup then for the above mentioned RMAN script I get following error:
****
RMAN-06003: ORACLE error from target database: RMAN-20208: UNTIL
CHANGE is before RESETLOGS change
****

Please note that query to get SCN still returns me 362799 so I had to
use 362799 in the RMAN script.
****
SQL> SELECT min(scn)
2 FROM (SELECT max(next_change#) scn
3 FROM v$archived_log
4 GROUP BY thread#);

MIN(SCN)
----------
362799
****

Please note the output of the list backup command at this point:
****
RMAN> list backup;

RMAN-03022: compiling command: list

List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ----------
----------------------
1 1 698720723 0 698720644 1 28-SEP-09

List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ----------------------
------------------------
1 1 1 AVAILABLE 28-SEP-09 BE_01kqb8c4_1_1

List of Datafiles Included
File Name LV Type Ckp SCN Ckp
Time
---- ------------------------------------- -- ---- ----------
-------------
1 C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF 0 Full 362797 28-
SEP-09
2 C:\ORACLE\ORADATA\ORCL\RBS01.DBF 0 Full 362797 28-
SEP-09
3 C:\ORACLE\ORADATA\ORCL\USERS01.DBF 0 Full 362797 28-
SEP-09
4 C:\ORACLE\ORADATA\ORCL\TEMP01.DBF 0 Full 362797 28-
SEP-09
5 C:\ORACLE\ORADATA\ORCL\TOOLS01.DBF 0 Full 362797 28-
SEP-09
6 C:\ORACLE\ORADATA\ORCL\INDX01.DBF 0 Full 362797 28-
SEP-09
7 C:\ORACLE\ORADATA\ORCL\DR01.DBF 0 Full 362797 28-
SEP-09
8 C:\ORACLE\ORADATA\ORCL\TEST01.DBF 0 Full 362797 28-
SEP-09

List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ----------
----------------------
4 4 698939872 0 698939794 5 30-SEP-09

List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ----------------------
------------------------
4 1 1 AVAILABLE 30-SEP-09 BE_05kqhuci_1_1

List of Datafiles Included
File Name LV Type Ckp SCN Ckp
Time
---- ------------------------------------- -- ---- ----------
-------------
1 C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF 0 Full 362846 30-
SEP-09
2 C:\ORACLE\ORADATA\ORCL\RBS01.DBF 0 Full 362846 30-
SEP-09
3 C:\ORACLE\ORADATA\ORCL\USERS01.DBF 0 Full 362846 30-
SEP-09
4 C:\ORACLE\ORADATA\ORCL\TEMP01.DBF 0 Full 362846 30-
SEP-09
5 C:\ORACLE\ORADATA\ORCL\TOOLS01.DBF 0 Full 362846 30-
SEP-09
6 C:\ORACLE\ORADATA\ORCL\INDX01.DBF 0 Full 362846 30-
SEP-09
7 C:\ORACLE\ORADATA\ORCL\DR01.DBF 0 Full 362846 30-
SEP-09
8 C:\ORACLE\ORADATA\ORCL\TEST01.DBF 0 Full 362846 30-
SEP-09

List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ----------
----------------------
6 6 699098593 0 699098517 7 01-OCT-09

List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ----------------------
------------------------
6 1 1 AVAILABLE 01-OCT-09 BE_07kqmpcl_1_1

List of Datafiles Included
File Name LV Type Ckp SCN Ckp
Time
---- ------------------------------------- -- ---- ----------
-------------
1 C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF 0 Full 362902 01-
OCT-09
2 C:\ORACLE\ORADATA\ORCL\RBS01.DBF 0 Full 362902 01-
OCT-09
3 C:\ORACLE\ORADATA\ORCL\USERS01.DBF 0 Full 362902 01-
OCT-09
4 C:\ORACLE\ORADATA\ORCL\TEMP01.DBF 0 Full 362902 01-
OCT-09
5 C:\ORACLE\ORADATA\ORCL\TOOLS01.DBF 0 Full 362902 01-
OCT-09
6 C:\ORACLE\ORADATA\ORCL\INDX01.DBF 0 Full 362902 01-
OCT-09
7 C:\ORACLE\ORADATA\ORCL\DR01.DBF 0 Full 362902 01-
OCT-09
8 C:\ORACLE\ORADATA\ORCL\TEST01.DBF 0 Full 362902 01-
OCT-09
****

Can anyone let me know what I need to do to restore and recover from
my second / third backups.

Thanks in advance,
Ganesh Tambat
Re: Issue with Oracle 8i recovery [message #424932 is a reply to message #424925] Tue, 06 October 2009 09:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This could be an old bug with 8i.
Try again without the RELEASE CHANNEL.
Quote:
RUN {
ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE';

RESTORE DATABASE UNTIL SCN 362799;

RECOVER DATABASE UNTIL SCN 362799;
RELEASE CHANNEL ch0;
alter database open resetlogs;
}


And please use CODE tags for readability.
Re: Issue with Oracle 8i recovery [message #424933 is a reply to message #424925] Tue, 06 October 2009 09:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And please post the complete log file (all the errors in exact sequence).
Re: Issue with Oracle 8i recovery [message #424938 is a reply to message #424925] Tue, 06 October 2009 11:18 Go to previous messageGo to next message
ganeshtambat123
Messages: 3
Registered: October 2009
Junior Member
Tried without release channel but it did not help. Pasting the RMAN output below:
RMAN> RUN {  ALLOCATE CHANNEL ch0     TYPE 'SBT_TAPE';
RESTORE     DATABASE     UNTIL SCN 362799;  RECOVER      DATABASE      UNTIL
 SCN 362799;
alter database open resetlogs;  }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch0
RMAN-08500: channel ch0: sid=14 devtype=SBT_TAPE
RMAN-08526: channel ch0: Symantec/BackupExec/1.1.0

RMAN-03022: compiling command: send
RMAN-06421: sent command to channel: ch0

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06003: ORACLE error from target database: RMAN-20208: UNTIL CHANGE is befor
e RESETLOGS change

RMAN>


[Updated on: Tue, 06 October 2009 11:37] by Moderator

Report message to a moderator

Re: Issue with Oracle 8i recovery [message #424948 is a reply to message #424938] Tue, 06 October 2009 11:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
do an rman
List incarnation


followed by
reset database to incarnation to_previous_incarnation.


and then restore and recover.
Re: Issue with Oracle 8i recovery [message #424955 is a reply to message #424938] Tue, 06 October 2009 12:26 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Was the archive log mode changed on the primary database?
Previous Topic: RMAN's cons & pros
Next Topic: Problem with recovery of database
Goto Forum:
  


Current Time: Sun Dec 22 18:07:08 CST 2024