Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL> shutdown IMMEDIATE
- DATABASE closed.
- DATABASE dismounted.
- ORACLE instance shut down.
- SQL> startup mount
- ORACLE instance started.
- Total SYSTEM Global Area 2505338880 bytes
- Fixed SIZE 2684688 bytes
- Variable SIZE 721422576 bytes
- DATABASE Buffers 1761607680 bytes
- Redo Buffers 19623936 bytes
- DATABASE mounted.
- SQL> ALTER DATABASE OPEN read only;
- DATABASE altered.
- RMAN> backup
- 2> TO platform='Linux IA (64-bit)'
- 3> DATABASE
- 4> ;
- Starting backup AT 20131002 07:18
- USING target DATABASE control FILE instead OF recovery catalog
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=123 device TYPE=DISK
- channel ORA_DISK_1: starting full datafile backup SET
- channel ORA_DISK_1: specifying datafile(s) IN backup SET
- input datafile FILE NUMBER=00003 name=+DATA/POLOLU/DATAFILE/sysaux.580.825898439
- input datafile FILE NUMBER=00001 name=+DATA/POLOLU/DATAFILE/SYSTEM.583.825898485
- input datafile FILE NUMBER=00004 name=+DATA/POLOLU/DATAFILE/undotbs1.586.825898533
- input datafile FILE NUMBER=00006 name=+DATA/POLOLU/DATAFILE/users.584.825898531
- channel ORA_DISK_1: starting piece 1 AT 20131002 07:18
- channel ORA_DISK_1: finished piece 1 AT 20131002 07:20
- piece handle=/app/oracle/product/12.1.0/db_1/dbs/09olci6p_1_1 tag=TAG20131002T071847 COMMENT=NONE
- channel ORA_DISK_1: backup SET complete, elapsed TIME: 00:01:15
- Finished backup AT 20131002 07:20
- RMAN> **end-of-FILE**
- RMAN> startup force nomount
- Oracle instance started
- Total SYSTEM Global Area 2505338880 bytes
- Fixed SIZE 2684688 bytes
- Variable SIZE 721422576 bytes
- DATABASE Buffers 1761607680 bytes
- Redo Buffers 19623936 bytes
- RMAN> @ restoreFromPlatformDatabase.rcv
- RMAN>
- RMAN> restore
- 2> FROM platform 'Linux IA (64-bit)'
- 3> foreign DATABASE
- 4> format '+DATA'
- 5> FROM backupset '/app/oracle/product/12.1.0/db_1/dbs/09olci6p_1_1'
- 6> ;
- Starting restore AT 20131002 07:29
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=414 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 ALL foreign files IN backup piece
- channel ORA_DISK_1: reading FROM backup piece /app/oracle/product/12.1.0/db_1/dbs/09olci6p_1_1
- channel ORA_DISK_1: restoring foreign FILE 3 TO +DATA
- channel ORA_DISK_1: restoring foreign FILE 1 TO +DATA
- channel ORA_DISK_1: restoring foreign FILE 4 TO +DATA
- channel ORA_DISK_1: restoring foreign FILE 6 TO +DATA
- channel ORA_DISK_1: foreign piece handle=/app/oracle/product/12.1.0/db_1/dbs/09olci6p_1_1
- channel ORA_DISK_1: restored backup piece 1
- channel ORA_DISK_1: restore complete, elapsed TIME: 00:01:56
- Finished restore AT 20131002 07:31
- RMAN> **end-of-FILE**
- RMAN> ALTER DATABASE mount;
- Statement processed
- released channel: ORA_DISK_1
- RMAN> recover DATABASE;
- Starting recover AT 20131002 07:33
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=240 device TYPE=DISK
- starting media recovery
- media recovery complete, elapsed TIME: 00:00:01
- Finished recover AT 20131002 07:33
- RMAN> ALTER DATABASE OPEN;
- Statement processed
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement