SQL> select dbid from v$database; DBID ---------- 847839442
RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\S NCFDBA20.ORA'; # default
RMAN> configure controlfile autobackup on; RMAN> backup database; SQL> select name from v$controlfile; NAME ------------------------------------------------------ C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\CONTROL01.CTL C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\CONTROL02.CTL C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\CONTROL03.CTL
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down.
Delete control files.
SQL> startup; ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1247876 bytes Variable Size 83887484 bytes Database Buffers 75497472 bytes Redo Buffers 7139328 bytes ORA-00205: error in identifying control file, check alert log for more info
RMAN> set dbid 847839442 RMAN> restore controlfile from autobackup; RMAN> alter database mount; RMAN> restore database; RMAN> recover database; RMAN> alter database open resetlogs; |