|
-
Control File Recovery
 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’;
}
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?
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
|
Reply With Quote