-
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
-
-
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’;
}
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
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
-
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...
PS: Pls check for correct syntax.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Do you have a controlfile to recover?
Is your controlfile part of your backup?
Is AUTOBACKUP CONTROLFILE on?
Ken
-
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?.
-
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
-
Originally Posted by greenchille
?? How to check AUTOBACKUP CONTROLFILE on?
"show all;" at the RMAN prompt.
Assistance is Futile...
-
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.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
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
|