Prosty Restore odtworzenie bazy z kopi

Wykonujemy polecenia

startup mount force;
configure controlfile autobackup off;
restore database;



Listing

RMAN> startup mount force;

Oracle instance started
database mounted

Total System Global Area     552402944 bytes

Fixed Size                     1384872 bytes
Variable Size                213913176 bytes
Database Buffers             331350016 bytes
Redo Buffers                   5754880 bytes

RMAN> configure controlfile autobackup off;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored

RMAN> restore database;

Starting restore at 15/06/08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to C:\ORACLEXE\APP\ORACLE\ORADATA\X
E\SYSTEM.DBF
channel ORA_DISK_1: restoring datafile 00002 to C:\ORACLEXE\APP\ORACLE\ORADATA\X
E\UNDOTBS1.DBF
channel ORA_DISK_1: restoring datafile 00003 to C:\ORACLEXE\APP\ORACLE\ORADATA\X
E\SYSAUX.DBF
channel ORA_DISK_1: restoring datafile 00004 to C:\ORACLEXE\APP\ORACLE\ORADATA\X
E\USERS.DBF
channel ORA_DISK_1: reading from backup piece C:\BACKUP\XE_2761598307_25_FULL_0P
Q8B520_1_1.DATABASE
channel ORA_DISK_1: piece handle=C:\BACKUP\XE_2761598307_25_FULL_0PQ8B520_1_1.DA
TABASE tag=TAG20150531T171751
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
Finished restore at 15/06/08