Alert log contents while cloning with RMAN
                                                 Last update (2009-11-11 16:31:19)
                                                                                                                   Date added (2009-11-11 15:04:58)

This are the contents of alert log while doing : Clone database with RMAN
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 1
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
  control_files            = /orandr/ANDR/controlfiles/control01.ctl, /orandr/ANDR/controlfiles/control02.ctl, /orandr/ANDR/controlfiles/control03.ctl
  db_file_name_convert     = /orandr/ANDR/datafiles/, /orandr/ANDR/datafiles_new/
  log_file_name_convert    = /orandr/ANDR/redologs/, /orandr/ANDR/redologs_new/
  db_block_size            = 8192
  compatible               = 9.2.0.0.0
  instance_name            = DUP
  background_dump_dest     = /orandr/ANDR/9.2.0/admin/DUP/bdump/
  user_dump_dest           = /orandr/ANDR/9.2.0/admin/DUP/udump/
  core_dump_dest           = /orandr/ANDR/9.2.0/admin/DUP/cdump/
  db_name                  = DUP
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Wed Nov 11 13:16:54 2009
Full restore complete of datafile 9 to datafile copy /orandr/ANDR/datafiles_new/dr01.dbf
  checkpoint is 6121602745376
Full restore complete of datafile 4 to datafile copy /orandr/ANDR/datafiles_new/tools01.dbf
  checkpoint is 6121602745376
Full restore complete of datafile 7 to datafile copy /orandr/ANDR/datafiles_new/mst_tab01.dbf
  checkpoint is 6121602745376
Wed Nov 11 13:22:31 2009
Full restore complete of datafile 3 to datafile copy /orandr/ANDR/datafiles_new/indx01.dbf
  checkpoint is 6121602745377
Full restore complete of datafile 5 to datafile copy /orandr/ANDR/datafiles_new/users01.dbf
  checkpoint is 6121602745377
Wed Nov 11 13:23:25 2009
Full restore complete of datafile 8 to datafile copy /orandr/ANDR/datafiles_new/undotbs_01.dbf
  checkpoint is 6121602745377
Wed Nov 11 13:29:40 2009
Full restore complete of datafile 1 to datafile copy /orandr/ANDR/datafiles_new/system01.dbf
  checkpoint is 6121602745379
Wed Nov 11 13:37:51 2009
Full restore complete of datafile 6 to datafile copy /orandr/ANDR/datafiles_new/testtab01.dbf
  checkpoint is 6121602745378
Wed Nov 11 13:38:10 2009
CREATE CONTROLFILE REUSE SET DATABASE "DUP" RESETLOGS ARCHIVELOG 
  MAXLOGFILES      5
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     1
  MAXLOGHISTORY      226
 LOGFILE
  GROUP  1 ( '/orandr/ANDR/redologs_new/redolog1.log' ) SIZE  104857600  REUSE,
  GROUP  2 ( '/orandr/ANDR/redologs_new/redolog2.log' ) SIZE  104857600  REUSE,
  GROUP  3 ( '/orandr/ANDR/redologs_new/redolog3.log' ) SIZE  104857600  REUSE,
  GROUP  4 ( '/orandr/ANDR/redologs_new/redolog4.log' ) SIZE  104857600  REUSE,
  GROUP  5 ( '/orandr/ANDR/redologs_new/redolog5.log' ) SIZE  104857600  REUSE
 DATAFILE
  '/orandr/ANDR/datafiles_new/system01.dbf'
 CHARACTER SET EL8ISO8859P7
Wed Nov 11 13:38:10 2009
Successful mount of redo thread 1, with mount id 73455426
Wed Nov 11 13:38:10 2009
Completed: CREATE CONTROLFILE REUSE SET DATABASE "DUP" RESETL
Switch of datafile 3 complete to datafile copy /orandr/ANDR/datafiles_new/indx01.dbf
  checkpoint is 6121602745377
Switch of datafile 4 complete to datafile copy /orandr/ANDR/datafiles_new/tools01.dbf
  checkpoint is 6121602745376
Switch of datafile 5 complete to datafile copy /orandr/ANDR/datafiles_new/users01.dbf
  checkpoint is 6121602745377
Switch of datafile 6 complete to datafile copy /orandr/ANDR/datafiles_new/testtab01.dbf
  checkpoint is 6121602745378
Switch of datafile 7 complete to datafile copy /orandr/ANDR/datafiles_new/mst_tab01.dbf
  checkpoint is 6121602745376
Switch of datafile 8 complete to datafile copy /orandr/ANDR/datafiles_new/undotbs_01.dbf
  checkpoint is 6121602745377
Switch of datafile 9 complete to datafile copy /orandr/ANDR/datafiles_new/dr01.dbf
  checkpoint is 6121602745376
Wed Nov 11 13:42:57 2009
alter database recover datafile list
 clear
Wed Nov 11 13:42:57 2009
Completed: alter database recover datafile list
 clear
Wed Nov 11 13:42:57 2009
alter database recover datafile list
 1 , 3 , 4 , 5 , 6 , 7 , 8 , 9
Media Recovery Datafile: 1
Media Recovery Datafile: 3
Media Recovery Datafile: 4
Media Recovery Datafile: 5
Media Recovery Datafile: 6
Media Recovery Datafile: 7
Media Recovery Datafile: 8
Media Recovery Datafile: 9
Completed: alter database recover datafile list
 1 , 3 , 4 , 
Wed Nov 11 13:42:57 2009
alter database recover if needed
 start until time 'NOV 08 2009 13:42:57' using backup controlfile
Media Recovery Start
Starting datafile 1 recovery in thread 1 sequence 10746
Datafile 1: '/orandr/ANDR/datafiles_new/system01.dbf'
Starting datafile 3 recovery in thread 1 sequence 10746
Datafile 3: '/orandr/ANDR/datafiles_new/indx01.dbf'
Starting datafile 4 recovery in thread 1 sequence 10746
Datafile 4: '/orandr/ANDR/datafiles_new/tools01.dbf'
Starting datafile 5 recovery in thread 1 sequence 10746
Datafile 5: '/orandr/ANDR/datafiles_new/users01.dbf'
Starting datafile 6 recovery in thread 1 sequence 10746
Datafile 6: '/orandr/ANDR/datafiles_new/testtab01.dbf'
Starting datafile 7 recovery in thread 1 sequence 10746
Datafile 7: '/orandr/ANDR/datafiles_new/mst_tab01.dbf'
Starting datafile 8 recovery in thread 1 sequence 10746
Datafile 8: '/orandr/ANDR/datafiles_new/undotbs_01.dbf'
Starting datafile 9 recovery in thread 1 sequence 10746
Datafile 9: '/orandr/ANDR/datafiles_new/dr01.dbf'
Media Recovery Log 
ORA-279 signalled during: alter database recover if needed
 start until time...
Wed Nov 11 13:47:11 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10746.dbf'
Wed Nov 11 13:47:11 2009
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10746.dbf
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 13:53:00 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10747.dbf'
Wed Nov 11 13:53:00 2009
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10747.dbf
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 13:59:13 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10748.dbf'
Wed Nov 11 13:59:13 2009
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10748.dbf
Wed Nov 11 13:59:33 2009
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 13:59:34 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10749.dbf'
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10749.dbf
Wed Nov 11 13:59:46 2009
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 13:59:46 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10750.dbf'
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10750.dbf
Wed Nov 11 14:00:00 2009
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 14:00:00 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10751.dbf'
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10751.dbf
Wed Nov 11 14:00:13 2009
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 14:00:13 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10752.dbf'
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10752.dbf
Wed Nov 11 14:00:27 2009
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 14:05:39 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10753.dbf'
Wed Nov 11 14:05:39 2009
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10753.dbf
Wed Nov 11 14:05:53 2009
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 14:05:53 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10754.dbf'
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10754.dbf
Wed Nov 11 14:06:06 2009
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 14:06:07 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10755.dbf'
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10755.dbf
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 14:06:14 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10756.dbf'
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10756.dbf
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 14:06:21 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10757.dbf'
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10757.dbf
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 14:11:33 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10758.dbf'
Wed Nov 11 14:11:33 2009
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10758.dbf
ORA-279 signalled during: alter database recover logfile '/orandr/ANDR/9.2.0...
Wed Nov 11 14:17:23 2009
alter database recover logfile '/orandr/ANDR/9.2.0/dbs/arch1_10759.dbf'
Wed Nov 11 14:17:23 2009
Media Recovery Log /orandr/ANDR/9.2.0/dbs/arch1_10759.dbf
Terminal Recovery: done UNTIL CHANGE 6121690133735
Media Recovery Complete
Completed: alter database recover logfile '/orandr/ANDR/9.2.0
Wed Nov 11 14:17:56 2009
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 3
Wed Nov 11 14:17:56 2009
alter database close 
ORA-1109 signalled during: alter database close...
Wed Nov 11 14:17:56 2009
alter database dismount 
Completed: alter database dismount
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Nov 11 14:18:01 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 1
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
  control_files            = /orandr/ANDR/controlfiles/control01.ctl, /orandr/ANDR/controlfiles/control02.ctl, /orandr/ANDR/controlfiles/control03.ctl
  db_file_name_convert     = /orandr/ANDR/datafiles/, /orandr/ANDR/datafiles_new/
  log_file_name_convert    = /orandr/ANDR/redologs/, /orandr/ANDR/redologs_new/
  db_block_size            = 8192
  compatible               = 9.2.0.0.0
  instance_name            = DUP
  background_dump_dest     = /orandr/ANDR/9.2.0/admin/DUP/bdump/
  user_dump_dest           = /orandr/ANDR/9.2.0/admin/DUP/udump/
  core_dump_dest           = /orandr/ANDR/9.2.0/admin/DUP/cdump/
  db_name                  = DUP
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Wed Nov 11 14:18:02 2009
CREATE CONTROLFILE REUSE SET DATABASE "DUP" RESETLOGS ARCHIVELOG 
  MAXLOGFILES      5
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     1
  MAXLOGHISTORY      226
 LOGFILE
  GROUP  1 ( '/orandr/ANDR/redologs_new/redolog1.log' ) SIZE  104857600  REUSE,
  GROUP  2 ( '/orandr/ANDR/redologs_new/redolog2.log' ) SIZE  104857600  REUSE,
  GROUP  3 ( '/orandr/ANDR/redologs_new/redolog3.log' ) SIZE  104857600  REUSE,
  GROUP  4 ( '/orandr/ANDR/redologs_new/redolog4.log' ) SIZE  104857600  REUSE,
  GROUP  5 ( '/orandr/ANDR/redologs_new/redolog5.log' ) SIZE  104857600  REUSE
 DATAFILE
  '/orandr/ANDR/datafiles_new/system01.dbf'
 CHARACTER SET EL8ISO8859P7
Wed Nov 11 14:18:02 2009
Successful mount of redo thread 1, with mount id 73424026
Wed Nov 11 14:18:02 2009
Completed: CREATE CONTROLFILE REUSE SET DATABASE "DUP" RESETL
Wed Nov 11 14:19:50 2009
Switch of datafile 3 complete to datafile copy /orandr/ANDR/datafiles_new/indx01.dbf
  checkpoint is 6121690133735
Switch of datafile 4 complete to datafile copy /orandr/ANDR/datafiles_new/tools01.dbf
  checkpoint is 6121690133735
Switch of datafile 5 complete to datafile copy /orandr/ANDR/datafiles_new/users01.dbf
  checkpoint is 6121690133735
Switch of datafile 6 complete to datafile copy /orandr/ANDR/datafiles_new/testtab01.dbf
  checkpoint is 6121690133735
Switch of datafile 7 complete to datafile copy /orandr/ANDR/datafiles_new/mst_tab01.dbf
  checkpoint is 6121690133735
Switch of datafile 8 complete to datafile copy /orandr/ANDR/datafiles_new/undotbs_01.dbf
  checkpoint is 6121690133735
Switch of datafile 9 complete to datafile copy /orandr/ANDR/datafiles_new/dr01.dbf
  checkpoint is 6121690133735
Wed Nov 11 14:20:04 2009
alter database open resetlogs
Wed Nov 11 14:20:04 2009
RESETLOGS after incomplete recovery UNTIL CHANGE 6121690133735
Resetting resetlogs activation ID 0 (0x0)
Wed Nov 11 14:20:04 2009
Errors in file /orandr/ANDR/9.2.0/rdbms/log/dup_ora_1451.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/orandr/ANDR/redologs_new/redolog1.log'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
Wed Nov 11 14:20:06 2009
Errors in file /orandr/ANDR/9.2.0/rdbms/log/dup_ora_1451.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/orandr/ANDR/redologs_new/redolog2.log'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
Wed Nov 11 14:20:07 2009
Errors in file /orandr/ANDR/9.2.0/rdbms/log/dup_ora_1451.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/orandr/ANDR/redologs_new/redolog3.log'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
Wed Nov 11 14:20:09 2009
Errors in file /orandr/ANDR/9.2.0/rdbms/log/dup_ora_1451.trc:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '/orandr/ANDR/redologs_new/redolog4.log'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
Wed Nov 11 14:20:11 2009
Errors in file /orandr/ANDR/9.2.0/rdbms/log/dup_ora_1451.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/orandr/ANDR/redologs_new/redolog5.log'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
Wed Nov 11 14:20:12 2009
LGWR: Primary database is in CLUSTER CONSISTENT mode
Assigning activation ID 73424026 (0x4605c9a)
Thread 1 opened at log sequence 1
  Current log# 5 seq# 1 mem# 0: /orandr/ANDR/redologs_new/redolog5.log
Successful open of redo thread 1
Wed Nov 11 14:20:12 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Nov 11 14:20:12 2009
SMON: enabling cache recovery
Wed Nov 11 14:20:13 2009
Dictionary check beginning
Tablespace 'TEMP1' #11 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Wed Nov 11 14:20:13 2009
SMON: enabling tx recovery
SMON: about to recover undo segment 5
SMON: mark undo segment 5 as available
Wed Nov 11 14:20:13 2009
Database Characterset is EL8ISO8859P7
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open resetlogs
Wed Nov 11 14:26:46 2009
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 
  '/orandr/ANDR/datafiles_new/temp01.dbf' SIZE 300M AUTOEXTEND OFF 
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M 
Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 
  '/ora
Wed Nov 11 14:27:44 2009
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp 
Wed Nov 11 14:27:44 2009
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search