[oracle@mulga ~]$ sqlplus '/as sysdba' SQL*Plus: Release 11.1.0.6.0 - Production on Tue May 4 14:07:31 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 3240239104 bytes Fixed Size 2148760 bytes Variable Size 1744832104 bytes Database Buffers 1476395008 bytes Redo Buffers 16863232 bytes Database mounted. SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@mulga ~]$ rman target / Recovery Manager: Release 11.1.0.6.0 - Production on Tue May 4 14:08:13 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: ORCL (DBID=1245901426, not open) RMAN> configure channel 1 device type disk format '/tmp/oracle_backup/%U.bak'; using target database control file instead of recovery catalog new RMAN configuration parameters: CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/tmp/oracle_backup/%U.bak'; new RMAN configuration parameters are successfully stored RMAN> backup database; Starting backup at 04-MAY-10 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=154 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=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf input datafile file number=00005 name=/u02/app/oracle/oradata/medware/medware_01.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf channel ORA_DISK_1: starting piece 1 at 04-MAY-10 channel ORA_DISK_1: finished piece 1 at 04-MAY-10 piece handle=/tmp/oracle_backup/01lcrab2_1_1.bak tag=TAG20100504T140834 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 04-MAY-10 channel ORA_DISK_1: finished piece 1 at 04-MAY-10 piece handle=/tmp/oracle_backup/02lcrabq_1_1.bak tag=TAG20100504T140834 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 04-MAY-10 RMAN> list backup 2> ; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 1 Full 1011.19M DISK 00:00:22 04-MAY-10 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20100504T140834 Piece Name: /tmp/oracle_backup/01lcrab2_1_1.bak List of Datafiles in backup set 1 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 889853 04-MAY-10 /u01/app/oracle/oradata/orcl/system01.dbf 2 Full 889853 04-MAY-10 /u01/app/oracle/oradata/orcl/sysaux01.dbf 3 Full 889853 04-MAY-10 /u01/app/oracle/oradata/orcl/undotbs01.dbf 4 Full 889853 04-MAY-10 /u01/app/oracle/oradata/orcl/users01.dbf 5 Full 889853 04-MAY-10 /u02/app/oracle/oradata/medware/medware_01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 2 Full 9.36M DISK 00:00:12 04-MAY-10 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20100504T140834 Piece Name: /tmp/oracle_backup/02lcrabq_1_1.bak SPFILE Included: Modification time: 04-MAY-10 SPFILE db_unique_name: ORCL Control File Included: Ckp SCN: 889853 Ckp time: 04-MAY-10 RMAN>exit Recovery Manager complete. [oracle@mulga ~]$ sqlplus '/as sysdba' SQL*Plus: Release 11.1.0.6.0 - Production on Tue May 4 14:11:23 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to an idle instance. SQL> startup force ORACLE instance started. Total System Global Area 3240239104 bytes Fixed Size 2148760 bytes Variable Size 1744832104 bytes Database Buffers 1476395008 bytes Redo Buffers 16863232 bytes Database mounted. Database opened. SQL> truncate table medware.benef; Table truncated. SQL> quit [oracle@mulga ~]$ sqlplus '/as sysdba' SQL*Plus: Release 11.1.0.6.0 - Production on Tue May 4 14:12:31 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup force mount; ORACLE instance started. Total System Global Area 3240239104 bytes Fixed Size 2148760 bytes Variable Size 1744832104 bytes Database Buffers 1476395008 bytes Redo Buffers 16863232 bytes Database mounted. SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@mulga ~]$ rman target / Recovery Manager: Release 11.1.0.6.0 - Production on Tue May 4 14:13:10 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: ORCL (DBID=1245901426, not open) RMAN> restore database; Starting restore at 04-MAY-10 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=154 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 /u01/app/oracle/oradata/orcl/system01.dbf channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/orcl/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/orcl/undotbs01.dbf channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/orcl/users01.dbf channel ORA_DISK_1: restoring datafile 00005 to /u02/app/oracle/oradata/medware/medware_01.dbf channel ORA_DISK_1: reading from backup piece /tmp/oracle_backup/01lcrab2_1_1.bak channel ORA_DISK_1: piece handle=/tmp/oracle_backup/01lcrab2_1_1.bak tag=TAG20100504T140834 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:16 Finished restore at 04-MAY-10 RMAN> RMAN> RMAN> recover database; Starting recover at 04-MAY-10 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 3 is already on disk as file /u01/app/oracle/oradata/orcl/redo03.log archived log file name=/u01/app/oracle/oradata/orcl/redo03.log thread=1 sequence=3 media recovery complete, elapsed time: 00:00:00 Finished recover at 04-MAY-10 RMAN> quit Recovery Manager complete. [oracle@mulga ~]$ sqlplus '/as sysdba' SQL*Plus: Release 11.1.0.6.0 - Production on Tue May 4 14:16:32 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter database open noresetlogs; Database altered. SQL> startup force; ORACLE instance started. Total System Global Area 3240239104 bytes Fixed Size 2148760 bytes Variable Size 1744832104 bytes Database Buffers 1476395008 bytes Redo Buffers 16863232 bytes Database mounted. Database opened. SQL> select count(*) from medware.benef; COUNT(*) ---------- 0