Cold Backup With Rman
#
C:\oracle>set NLS_LANG=English.UTF8 C:\oracle>rman target / nocatalog Recovery Manager: Release 11.1.0.6.0 - Production on Tue Feb 26 10:46:04 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: DBCAMIN (DBID=898998132, not open) using target database control file instead of recovery catalog
#
RMAN> shutdown immediate; database dismounted Oracle instance shut down
#
RMAN> startup mount; connected to target database (not started) Oracle instance started database mounted Total System Global Area 313860096 bytes Fixed Size 1332892 bytes Variable Size 159385956 bytes Database Buffers 146800640 bytes Redo Buffers 6340608 bytes
#
RMAN> show all; RMAN configuration parameters for database with db_unique_name DBCAMIN are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default 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 COMPRESSION ALGORITHM 'BZIP2'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\SNCFDBCAMIN.ORA'; # default
#
RMAN> backup full database; Starting backup at 26-FEB-08 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=55 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=C:\ORACLE\ORADATA\DBCAMIN\SYSTEM01.DBF input datafile file number=00003 name=C:\ORACLE\ORADATA\DBCAMIN\UNDOTBS01.DBF input datafile file number=00002 name=C:\ORACLE\ORADATA\DBCAMIN\SYSAUX01.DBF input datafile file number=00004 name=C:\ORACLE\ORADATA\DBCAMIN\USERS01.DBF channel ORA_DISK_1: starting piece 1 at 26-FEB-08 channel ORA_DISK_1: finished piece 1 at 26-FEB-08 piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\DBCAMIN\BACKUPSET\2008_02_26\O1_MF_NNNDF_TAG20080226T104828_3W6VZKT1_.BKP tag=TAG20080226T104828 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25 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 26-FEB-08 channel ORA_DISK_1: finished piece 1 at 26-FEB-08 piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\DBCAMIN\BACKUPSET\2008_02_26\O1_MF_NCSNF_TAG20080226T104828_3W6W0H9X_.BKP tag=TAG20080226T104828 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 26-FEB-08
#
RMAN> backup current controlfile; Starting backup at 26-FEB-08 using channel ORA_DISK_1 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 channel ORA_DISK_1: starting piece 1 at 26-FEB-08 channel ORA_DISK_1: finished piece 1 at 26-FEB-08 piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\DBCAMIN\BACKUPSET\2008_02_26\O1_MF_NCNNF_TAG20080226T104920_3W6W17FC_.BKP tag=TAG20080226T104920 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 26-FEB-08
#
RMAN> sql 'alter database backup controlfile to trace'; sql statement: alter database backup controlfile to trace
#
RMAN> sql 'create pfile from spfile'; sql statement: create pfile from spfile
#
RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 1 Full 180.15M DISK 00:00:22 26-FEB-08 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20080226T104828 Piece Name: C:\ORACLE\FLASH_RECOVERY_AREA\DBCAMIN\BACKUPSET\2008_02_26\O1_MF_NNNDF_TAG20080226T104828_3W6VZKT1_.BKP List of Datafiles in backup set 1 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 211645 26-FEB-08 C:\ORACLE\ORADATA\DBCAMIN\SYSTEM01.DBF 2 Full 211645 26-FEB-08 C:\ORACLE\ORADATA\DBCAMIN\SYSAUX01.DBF 3 Full 211645 26-FEB-08 C:\ORACLE\ORADATA\DBCAMIN\UNDOTBS01.DBF 4 Full 211645 26-FEB-08 C:\ORACLE\ORADATA\DBCAMIN\USERS01.DBF BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 2 Full 9.36M DISK 00:00:05 26-FEB-08 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20080226T104828 Piece Name: C:\ORACLE\FLASH_RECOVERY_AREA\DBCAMIN\BACKUPSET\2008_02_26\O1_MF_NCSNF_TAG20080226T104828_3W6W0H9X_.BKP SPFILE Included: Modification time: 26-FEB-08 SPFILE db_unique_name: DBCAMIN Control File Included: Ckp SCN: 211645 Ckp time: 26-FEB-08 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 3 Full 9.33M DISK 00:00:07 26-FEB-08 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20080226T104920 Piece Name: C:\ORACLE\FLASH_RECOVERY_AREA\DBCAMIN\BACKUPSET\2008_02_26\O1_MF_NCNNF_TAG20080226T104920_3W6W17FC_.BKP Control File Included: Ckp SCN: 211645 Ckp time: 26-FEB-08
#
RMAN> sql 'alter database open'; sql statement: alter database open
#
RMAN> backup database plus archivelog delete all input; RMAN> quit Recovery Manager complete.
#
C:\oracle>sqlplus "/ as sysdba" SQL*Plus: Release 11.1.0.6.0 - Production on Tue Feb 26 10:56:02 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 11 Current log sequence 13 SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options