A reader, April 27, 2011 - 9:13 pm UTC
Thanks , Tom.
Here is the order , I see in recovering to a different directory structure in new host.
Please advise how to apply online redo logs / point me to the link in oracle documentation.
1) restore spfile from flash recovery area ( FRA).
2) restore controlfile from FRA.
3) catalog backupsets
4) restore & recover to the most recent archived logs ?
5) create online redo logs ( as the online redo logs are stored in a new directory structure in the new host,
though the online logs are on the source host.) .
April 28, 2011 - 7:30 am UTC
A reader, April 30, 2013 - 3:14 pm UTC
<code>
I am trying to backup a database in noarchivelog .
As we can see , the database is not open ( it is only mounted) . Still RMAN complains about ORA-19602 .
I did shutdown the database clean and mounted it.
C:>rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Apr 30 11:03:04 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ZDBRD (DBID=3478497590, not open)
RMAN> backup database;
Starting backup at 30-APR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=189 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/30/2013 11:03:08
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
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 30-APR-13
channel ORA_DISK_1: finished piece 1 at 30-APR-13
piece handle=C:\APP\ORACLE\FAST_RECOVERY_AREA\ZDBRD\BACKUPSET\2013_04_30\O1_MF_NCSNF_TAG20130430T110308_8QZQ9FSF_.BKP tag=TAG20130430T110308 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/30/2013 11:03:08
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN>
After this , I went into another session to open the database and see if there are if there are any corruption . I see none.
What am I missing ? Please let me know.
SQL> alter database open ;
Database altered.
SQL> select * from v$database_block_corruption;
no rows selected
SQL> select dbid, name dbname, open_mode, database_role,
2 to_char(created,'dd-Mon-YYYY hh24:mi:ss') created,
3 to_char(resetlogs_time,'dd-Mon-YYYY hh24:mi:ss') resetlogs_time
4 from v$database;
DBID DBNAME OPEN_MODE DATABASE_ROLE CREATED
---------- --------- -------------------- ---------------- --------------------
RESETLOGS_TIME
--------------------
3478497590 ZDBRD READ WRITE PRIMARY 22-Apr-2013 10:23:50
22-Apr-2013 10:23:52
</code>