Oracle Consulting, Oracle Support and Oracle Training by Spyridon N. Kaparelis
osCommerce

Oracle

 My Account      
  Oracle Scripts (Search) » Categories » Administration » Backup - Recovery » My Account          
Categories
Free Oracle Support (1)
Administration-> (120)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (11)
  Database files (5)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Export Import Datapump (2)
  Jobs (2)
  Mview (2)
  Networking (2)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles (1)
  Rollback - Undo (8)
  Segments (2)
  Sequences (2)
  Sessions (14)
  SGA (10)
  Tables (10)
  Tablespaces (9)
  Temp (5)
  Transactions (1)
  Users (3)
FlexCube (4)
ORA errors (14)
Oracle Application Server (1)
Oracle APPS DBA-> (38)
Oracle APPS DBA jobs (1)
Oracle Books (18)
Oracle RAC (3)
Oracle Real Cases (29)
Oracle Security (6)
Oracle SQL tricks (32)
Other Oracle sites (3)
Performance Tuning-> (53)
Site info
About Spyridon N. Kaparelis
Privacy Notice & Disclaimer
Buy Oracle APPS DBA Books
Ask for Free Oracle Support
Alert log contents while cloning with RMAN

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

Added by Spyridon N. Kaparelis at Wednesday 11 November, 2009
Notifications more
NotificationsNotify me of updates to Alert log contents while cloning with RMAN
Tell A Friend
 
Reviews more
Write ReviewWrite review for the script
Read Latest Oracle News
Search at the site
 
Press Enter to search

Advanced Search
Search Error Messages

Oracle8i
Oracle9i
Oracle10g
Oracle11g
Search Oracle Docs

Metalink
Oracle8i
Oracle9i
Oracle10g
Oracle11g
  Wednesday 08 September, 2010   Created by: Spyridon N. Kaparelis          136620 page views since Tuesday 27 October, 2009  


osCommerce
Oracle APPS DBA Kaparelis | Oracle RAC | Oracle PLSQL | Oracle Tips | Oracle Consulting | Oracle Metalink | Oracle Support Oracle Training | Oracle Certification | Oracle Articles | Oracle DBA | Oracle Magazine | Oracle User Groups Oracle 7.3 Oracle 8 Oracle 8i Oracle9i Oracle10g Oracle11g EBS E-Business Suite 11.5.10 Oracle Apps Tuning Oracle SGA tuning sql tracing oracle session oracle errros ORA error ORA-600 Ora-00600 oracle jobs dba jobs apps dba jobs oracle experts oracle guru oracle oracle real application cluster oracle index oracle optimazation query oracle explain plan query optimization oracle I/O oracle memory tuning oracle xstress test oracle education oracle university oracle certification OCP OCA oracle support contracts oracle monitoring RAC interconnect developer oracle forms reports oracle application server Rman spyros dba oracle backup Veritas recovery catalog rcvcat oracle Σπυρίδων Καπαρέλης Ora-00600:[] Sp???d?? ?. ?apa????? oracle monitor daily operations free oracle support free consulting oracle seminars oracle arhitecture Unix linux HP-UX AIX Sun Solaris Windows TAR Service Request Metalink oracle disaster recovery oracle Data Guard Oracle Database Administrator Oracle Services low cost oracle support oracle patches upgrades apps dba spyros patch upgrade oracle opatch OUI export import oracle data pump ADDM ASM oracle OAS PGA shared pool ?p?st????? Oracle Application Server 10g consultans Oracle ERP CRM Apache WebUtil oracle 10g 11g 12g New Features Oracle courses development Oracle News forums Oracle Technical Docs FAQ Oracle Professionals Oracle DataCenter Data Center IT Oracle prices oracle software pricelist oracle carriers Oracle RDBMS Oracle Σπύρος Καπαρέλης Oracle Fusion Spiros Kaparelis oracle Spyros Kaparelis