Database Reference
In-Depth Information
Here is an example of the RMAN code:
RMAN> Startup nomount;
connected to target database (not started)
Oracle instance started
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 369099668 bytes
Database Buffers 159383552 bytes
Redo Buffers 5844992 bytes
RMAN> Restore controlfile from autobackup;
Starting restore at 28-SEP-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=153 device type=DISK
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130928
channel ORA_DISK_1: AUTOBACKUP found:
c:\oracle\controlfilebackup\c-437680418-20130928-00
channel ORA_DISK_1: restoring control file from AUTOBACKUP
c:\oracle\controlfilebackup\c-437680418-20130928-00
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=C:\ORACLE\ORADATA\RCAT\CONTROL01.CTL
output file name=C:\ORACLE\ORADATA\RCAT\CONTROL02.CTL
output file name=C:\ORACLE\ORADATA\RCAT\CONTROL03.CTL
Finished restore at 28-SEP-13
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> recover database;
Starting recover at 28-SEP-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=153 device type=DISK
starting media recovery
archived log for thread 1 with sequence 13 is already on disk as file
C:\ORACLE\ORADATA\RCAT\REDO01.LOG
archived log for thread 1 with sequence 14 is already on disk as file
C:\ORACLE\ORADATA\RCAT\REDO02.LOG
archived log file name=C:\ORACLE\ORADATA\RCAT\REDO01.LOG thread=1 sequence=13
archived log file name=C:\ORACLE\ORADATA\RCAT\REDO02.LOG thread=1 sequence=14
media recovery complete, elapsed time: 00:00:01
Finished recover at 28-SEP-13
Search WWH ::
Custom Search