Control file recovery, from RMAN

Printable View

09-26-2006, 07:12 PM
greenchille

Control file recovery, from RMAN

Hi
(ORACLE VERSION 8.1.7.4)
I am testing my rman backup and recovery. Backup was successfull.
The script for my backup is
run {
${channel1}
${channel2}
backup incremental level ${inclevel}
filesperset 5
tag ${mytag}
format
'${format}.bus' database include current controlfile;
sql 'alter system archive log current';
backup filesperset 50
archivelog all
format
'${format}.bar'${format_arc_del};
release channel c1;
release channel c2;
}

as my format is *.bus
------------
Now to the question, I was able to recover the database using rman, if the controlfile is good. If I lost the control file?, so I want to test the recover the control file using the latest rman backup (here it is full backup).
I tried all the sorts.. couldn't
Any Ideas.
Thx
C
09-27-2006, 03:09 AM
davey23uk

what did you try
09-27-2006, 12:16 PM
LKBrwn_DBA

Just restore the cotrolfile:

PHP Code:

CONNECT TARGET / CONNECT CATALOG RMANCAT/FOOBAR@RMAN STARTUP FORCE NOMOUNT PFILE=$ORACLE_HOME/DBS/INIT.ORA RUN { ALLOCATE CHANNEL CH1 TYPE DISK; SET UNTIL SCN=1447485626; RESTORE CONTROLFILE; SQL ‘ALTER DATABASE MOUNT’; }

:rolleyes:
09-27-2006, 01:58 PM
greenchille

hello Lkbrwn
I am connecting to rman with 'no catalog' option. Are the same steps do follow. How do we get the SCN?
Thx
Appreciate your responce
C
09-27-2006, 03:41 PM
LKBrwn_DBA

Without catalog, you may need to supply the backup file name -- no SCN necesary (yet), but you need to set the dbid:

PHP Code:

SET DBID=<integer> RUN { ALLOCATE CHANNEL CH1 TYPE DISK; RESTORE CONTROLFILE FROM FILE '<path>/<bkp file>'; SQL ‘ALTER DATABASE MOUNT’; }

To restore the DB you may need an SCN or SET UNTIL TIME...
:D

PS: Pls check for correct syntax.
09-27-2006, 03:53 PM
KenEwald

Do you have a controlfile to recover?
Is your controlfile part of your backup?
Is AUTOBACKUP CONTROLFILE on?

Ken
09-27-2006, 06:02 PM
greenchille

Hi Brwn,
I tried what you said but, it
RUN {
2> ALLOCATE CHANNEL CH1 TYPE DISK;
3> RESTORE CONTROLFILE FROM FILE '/backup/prod/backup/full/rman_PROD_601742701_0jhtrnbd.bus';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "tag"
RMAN-01008: the bad identifier was: FILE
RMAN-01007: at line 3 column 26 file: standard input

Got the above error.
Any idea?.
09-27-2006, 06:05 PM
greenchille

hello Ken
As part of my backup. I did the following things
for there i am include the control file too
***
format
'${format}.bus' database include current controlfile;
sql 'alter system archive log current';
*****
(can check my Question on top)
format="$disk_full/rman_%d_%t_%u"
disk_full =/backup/xx/yy/full/

?? How to check AUTOBACKUP CONTROLFILE on?
Thx
C
09-28-2006, 04:42 AM
waitecj

Quote:

Originally Posted by greenchille

?? How to check AUTOBACKUP CONTROLFILE on?

"show all;" at the RMAN prompt.
09-28-2006, 10:26 AM
LKBrwn_DBA

Quote:

Originally Posted by greenchille

Hi Brwn,
I tried what you said but, it
RUN {
2> ALLOCATE CHANNEL CH1 TYPE DISK;
3> RESTORE CONTROLFILE FROM FILE '/backup/prod/backup/full/rman_PROD_601742701_0jhtrnbd.bus';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "tag"
RMAN-01008: the bad identifier was: FILE
RMAN-01007: at line 3 column 26 file: standard input

Got the above error.
Any idea?.

That is why I said "Check for correct syntax", I kinda posted from memory.

Try removing the "FILE" word. :p
09-28-2006, 01:43 PM
greenchille

Hello Brwn
Sorry abt that. I checked the syntax and did the following.
RMAN> RUN {
2> ALLOCATE CHANNEL CH1 TYPE DISK;
3> RESTORE CONTROLFILE FROM '/backup/prod/backup/full/rman_PROD_601742701_0jhtrnbd.bus';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "single-quoted-string": expecting one of: "tag"
RMAN-01007: at line 3 column 26 file: standard input

Btw, I have 6 rman backup files in that folder.. (from fullbackup), SHall i need to list all the files.. or 1 file is good?
Thx
C
09-28-2006, 01:44 PM
greenchille

Quote:

Originally Posted by waitecj

"show all;" at the RMAN prompt.

RMAN> show all;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "allocate, alter, beginline, catalog, change, connect, create, crosscheck, configure, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, register, release, replace, report, renormalize, reset, resync, rman, rpct"
RMAN-01008: the bad identifier was: show
RMAN-01007: at line 1 column 1 file: standard input

--------------
As this is version 8i. it works in 9i/10g..
AM I right?
09-28-2006, 02:33 PM
LKBrwn_DBA

It appears that for Oracle version 8i the procedure is different, please check the 8i manual, specially the section "To restore the control file to a new location without a recovery catalog" :confused:

PS: Avoid this type of headache, use an RMAN catalog. ;)
09-29-2006, 04:21 AM
waitecj

Quote:

Originally Posted by greenchille

RMAN-01005: syntax error: found "single-quoted-string": expecting one of: "tag"

Apologies about the "show all" thing... I don't have any 8i databases around to test, but the documentation should clear that right up for you.

Lets have a look at the script you use to backup the database and controlfile. Are you using tags to identify your backupsets?
09-30-2006, 04:49 AM
M.Shakeel Azeem

Quote:

Originally Posted by LKBrwn_DBA

Just restore the cotrolfile:

PHP Code:

CONNECT TARGET / CONNECT CATALOG RMANCAT/FOOBAR@RMAN STARTUP FORCE NOMOUNT PFILE=$ORACLE_HOME/DBS/INIT.ORA RUN { ALLOCATE CHANNEL CH1 TYPE DISK; [B]SET UNTIL SCN=1447485626;[/B] RESTORE CONTROLFILE; SQL ‘ALTER DATABASE MOUNT’; }

:rolleyes:

is Scn# optional or mandatory?
if SCN# is mandatory then how can we determine the SCN No?
09-30-2006, 05:24 AM
M.Shakeel Azeem

Control File Recovery

Quote:

Originally Posted by LKBrwn_DBA

Just restore the cotrolfile:

PHP Code:

CONNECT TARGET / CONNECT CATALOG RMANCAT/FOOBAR@RMAN STARTUP FORCE NOMOUNT PFILE=$ORACLE_HOME/DBS/INIT.ORA RUN { ALLOCATE CHANNEL CH1 TYPE DISK; SET UNTIL SCN=1447485626; RESTORE CONTROLFILE; SQL ‘ALTER DATABASE MOUNT’; }

:rolleyes:

But if the database structure(a tablespace has been added) has been changed since last backup of database
is that an optimal solution to just restore the control file and DB will be in running state?
or we have to recover database using backup control file?
10-02-2006, 09:22 AM
LKBrwn_DBA

Quote:

Originally Posted by M.Shakeel Azeem

But if the database structure(a tablespace has been added) has been changed since last backup of database
is that an optimal solution to just restore the control file and DB will be in running state?
or we have to recover database using backup control file?

NO, the original question was "How do I restore controlfile from backup?".

After restoring controlfile, there is need to restore database.

Quote:

Originally Posted by M.Shakeel Azeem

is Scn# optional or mandatory?
if SCN# is mandatory then how can we determine the SCN No?

Unless you have have ALL archive and redo logs available you need to do point-in-time recovery, which requires either an SCN or a timestamp.

To locate SCN you would need the rman 'LOG' generated at the time of the backup --or-- from rman catalog if you have one.
:D