Oracle rman database backup and recovery in non-archive mode, mongolerman

Oracle rman database backup and recovery in non-archive mode, mongolerman
1. database Backup SQL> archive log list in non-archive mode; automatic archiving in non-archive mode in Database Log mode disable the archiving end point USE_DB_RECOVERY_FILE_DEST the earliest online log sequence 3244 the current log sequence 3246 RMAN> run 2> {3> allocate channel t1 type disk; 4> backup database format 'e: \ rman_bak \ 20111103 \ df _ % t _ % s _ % p. bak '; 5 >}use the target database control file to replace the channel for restoring directory allocation: t1 channel t1: SID = 14 device type = DISK start backup from March 11-11 to channel t1: starting all data files backup set channel t1: specifying the data file RMAN-03009 in the backup set: backup command (on t1 channel, on 10:21:43) failed ORA-19602: unable to back up or copy the active file in NOARCHIVELOG mode to continue to execute other job steps, will not re-run the failed job channel t1: starting all data file backup set channel t1: the data file backup set in the specified backup set includes the current control file backup set including the current SPFILE channel t1: the starting segment 1 in the 03-11 month-11 channel t1: completed segment 1 from March 11 to April 11 handle = E: \ RMAN_BAK \ 20111103 \ DF_766232503_2_1.BAK mark = TAG20111103T102143 comment = NONE channel t1: Backup set completed, after time: 00: 00: 01 release channel: t1 RMAN-00571: ========================================================== ============================== RMAN-00569: ================ error message stack follows ============================ RMAN-00571: ========================================================== ============================== RMAN-03009: backup command (on t1 channel, on 10:21:43) failed ORA-19602: unable to back up or copy the active file RMAN> shutdown immediate database disabled database uninstalled Oracle instance disabled RMAN> startup mount connected to target database (not started) oracle instance started Database loaded system global region total 535662592 bytes Fixed Size 1375792 bytes Variable Size 411042256 bytes Database Buffers 117440512 bytes Redo Buffers 5804032 bytes RMAN> run 2> {3> allocate channel t1 type disk; 4> backup database format 'e: \ rman_bak \ 20111103 \ df _ % t _ % s _ % p. bak '; 5 >}allocated channel: t1 channel t1: SID = 133 device type = DISK start backup on-11 channel t1: starting all data file backup sets channel t1: the input data file of the data file in the specified backup set is: File No. = 00004 name = D: \ ORACLE \ ORADATA \ ORCL \ USERS01.DBF input data file: File No. = 00001 name = D: \ ORACLE \ ORADATA \ ORCL \ SYSTEM01.DBF input data file: file number = 00005 name = D: \ ORACLE \ ORADATA \ ORCL \ TEST01.DBF input data file: file number = 00006 name = D: \ ORACLE \ ORADATA \ ORCL \ UNDOTBS02.DBF input data file: file number = 00002 name = D: \ ORACLE \ ORADATA \ ORCL \ SYSAUX01.DBF channel t1: starting segment 1 in March 11-11 channel t1: Completed segment 1 in March 11-11 handle = E: \ RMAN_BAK \ 20111103 \ DF_766232799_3_1.BAK mark = TAG20111103T102639 note = NONE channel t1: Backup set completed; Time: 00: 01: 55 channel t1: starting all data file backup set channels t1: the data file backup set in the specified backup set includes the current control file backup set including the current SPFILE channel t1: the starting segment 1 in the 03-11 month-11 channel t1: completed segment 1 from March 11 to April 11 handle = E: \ RMAN_BAK \ 20111103 \ DF_766232915_4_1.BAK mark = TAG20111103T102639 comment = NONE channel t1: Backup set completed, after time: 00: 00: 01. The backup channel released from March 11 to April 11 is: t1 2. restore the RMAN database in non-archive mode> shutdown immediatedatabase closed database dismounted Oracle instance shut downRMAN> startup mountconnected to target database (not started) oracle instance started database mountedTotal System Global Area 535662592 bytesFixed Size 1375792 bytes Variable Size 411042256 bytes Database Buffers 117440512 bytes Redo Buffers 5804032 bytesRMAN> restore database; Starting restore at specified allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID = 133 device type = DISKchannel 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 D: \ ORACLE \ ORADATA \ ORCL \ SYSTEM01.DBF channel ORA_DISK_1: restoring datafile 00002 to D: \ ORACLE \ ORADATA \ ORCL \ SYSAUX01.DBF channel ORA_DISK_1: restoring datafile 00004 to D: \ ORACLE \ ORADATA \ ORCL \ USERS01.DBF channel ORA_DISK_1: restoring datafile 00005 to D: \ ORACLE \ ORADATA \ ORCL \ TEST01.DBF channel ORA_DISK_1: restoring datafile 00006 to D: \ ORACLE \ ORADATA \ ORCL \ UNDOTBS02.DBF channel ORA_DISK_1: reading from backup piece E: \ RMAN_BAK \ 20111103 \ DF_766235030_5_1.BAK channel ORA_DISK_1: piece handle = E: \ RMAN_BAK \ 20111103 \ partition tag = TAG20111103T110349 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:02:35 Finished restore at 03-NOV-11RMAN> alter database open; RMAN-00571: ========================================================== ============================== RMAN-00569: ================ error message stack follows ============================ RMAN-00571: ========================================================== ============================== RMAN-03002: failure of alter db command at 11/03/2011 14:10:03 ORA-01113: file 1 needs media recovery ORA-01110: data file 1: 'd: \ ORACLE \ ORADATA \ ORCL \ system01.dbf' RMAN> recover database; starting recover at 03-NOV-11 using channel ORA_DISK_1starting media recoveryarchived log for thread 1 with sequence 3246 is already on disk as file D: \ ORACLE \ ORADATA \ ORCL \ REDO03.LOG archived log for thread 1 with sequence 3247 is already on disk as file D: \ ORACLE \ ORADATA \ ORCL \ REDO01.LOG archived log file name = D: \ ORACLE \ ORADATA \ ORCL \ REDO03.LOG thread = 1 sequence = 3246 archived log file name = D: \ ORACLE \ ORADATA \ ORCL \ REDO01.LOG thread = 1 sequence = 3247 media recovery complete, elapsed time: 00:00:09 Finished recover at 03-NOV-11RMAN> alter database open; RMAN-00571: ========================================================== ============================== RMAN-00569: ================ error message stack follows ============================ RMAN-00571: ========================================================== ============================== RMAN-03002: failure of alter db command at 14:10:30 ORA-01589: must use RESETLOGS or NORESETLOGS option for database openRMAN> alter database open resetlogs; database opened