Home » RDBMS Server » Backup & Recovery » clone db from datafiles (Oracle10g, 10.2.0, Windows XP)
clone db from datafiles [message #401098] Fri, 01 May 2009 10:15 Go to next message
maverick1168
Messages: 5
Registered: May 2009
Location: rome
Junior Member
Hi!

I have duplicated all datafiles (system, aux, user, undo, temp,etc.), control file, pfile of a DB shut-downed in normal mode. Now I have to install oracle on another server and duplicate same DB using datafiles. Starting from oracle server installation what step i have to follow? Thanx a lot in advance!

Re: clone db from datafiles [message #401099 is a reply to message #401098] Fri, 01 May 2009 10:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please search the forum for cold copy restore.
Essentially you install same version oracle, copy the files , create pfile and mount.
Re: clone db from datafiles [message #401125 is a reply to message #401099] Fri, 01 May 2009 13:28 Go to previous messageGo to next message
maverick1168
Messages: 5
Registered: May 2009
Location: rome
Junior Member
Thanks for the answer.

I did it.

but i can do only mount of db. If i try:

alter database open;

ORA-00603 ORACLE server session terminated by fatal error.

Confused
Re: clone db from datafiles [message #401126 is a reply to message #401125] Fri, 01 May 2009 13:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
check the alert log for specific erros and trace files.
Re: clone db from datafiles [message #401127 is a reply to message #401126] Fri, 01 May 2009 13:43 Go to previous messageGo to next message
maverick1168
Messages: 5
Registered: May 2009
Location: rome
Junior Member
This is last log related:

Shutting down instance (abort)
Fri May 01 20:39:40 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 75497472
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
sga_target = 251658240
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\TELECOMN\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\TELECOMN\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\TELECOMN\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 163577856
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=TelecomNXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\TELECOMNIUMA\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\TELECOMNIUMA\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\TELECOMNIUMA\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\TELECOMNIUMA\CDUMP
db_name = TelecomN
db_unique_name = TelecomNiuma
open_cursors = 300
pga_aggregate_target = 82837504
PMON started with pid=2, OS id=3824
PSP0 started with pid=3, OS id=2348
MMAN started with pid=4, OS id=2712
DBW0 started with pid=5, OS id=424
LGWR started with pid=6, OS id=2856
CKPT started with pid=7, OS id=2860
SMON started with pid=8, OS id=2864
RECO started with pid=9, OS id=2868
CJQ0 started with pid=10, OS id=2900
MMON started with pid=11, OS id=2884
Fri May 01 20:39:40 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2916
Fri May 01 20:39:40 2009
starting up 1 shared server(s) ...
Fri May 01 20:39:41 2009
ALTER DATABASE MOUNT
Fri May 01 20:39:45 2009
Setting recovery target incarnation to 2
Fri May 01 20:39:45 2009
Successful mount of redo thread 1, with mount id 3499001485
Fri May 01 20:39:45 2009
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri May 01 20:39:56 2009
alter database open
Fri May 01 20:39:56 2009
Beginning crash recovery of 1 threads
Fri May 01 20:39:57 2009
Started redo scan
Fri May 01 20:39:57 2009
Completed redo scan
59 redo blocks read, 15 data blocks need recovery
Fri May 01 20:39:57 2009
Started redo application at
Thread 1: logseq 531, block 3
Fri May 01 20:39:57 2009
Recovery of Online Redo Log: Thread 1 Group 2 Seq 531 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\TELECOMN\REDO02.LOG
Fri May 01 20:39:57 2009
Completed redo application
Fri May 01 20:39:57 2009
Completed crash recovery at
Thread 1: logseq 531, block 62, scn 9331316264575
15 data blocks read, 15 data blocks written, 59 redo blocks read
Fri May 01 20:39:58 2009
Thread 1 advanced to log sequence 532
Thread 1 opened at log sequence 532
Current log# 3 seq# 532 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\TELECOMN\REDO03.LOG
Successful open of redo thread 1
Fri May 01 20:39:58 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri May 01 20:39:58 2009
SMON: enabling cache recovery
Fri May 01 20:39:59 2009
Successfully onlined Undo Tablespace 1.
Fri May 01 20:39:59 2009
SMON: enabling tx recovery
Fri May 01 20:39:59 2009
Database Characterset is WE8MSWIN1252
Fri May 01 20:40:00 2009
Errors in file c:\oracle\product\10.2.0\admin\telecomniuma\udump\telecomn_ora_1656.trc:
ORA-00600: codice di errore interno, argomenti: [4194], [10], [10], [], [], [], [], []

DEBUG: Replaying xcb 0x1da06bd8, pmd 0x1db9e4a8 for failed op 8
Doing block recovery for file 2 block 3685
No block recovery was needed
Fri May 01 20:40:14 2009
Errors in file c:\oracle\product\10.2.0\admin\telecomniuma\bdump\telecomn_smon_2864.trc:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], []

Fri May 01 20:40:17 2009
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 1 out of maximum 100 non-fatal internal errors.
Fri May 01 20:40:21 2009
Errors in file c:\oracle\product\10.2.0\admin\telecomniuma\bdump\telecomn_smon_2864.trc:
ORA-00600: internal error code, arguments: [4194], [53], [51], [], [], [], [], []

Doing block recovery for file 2 block 861
Block recovery from logseq 532, block 61 to scn 9331316264747
Fri May 01 20:40:26 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 532 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\TELECOMN\REDO03.LOG
Block recovery stopped at EOT rba 532.63.16
Block recovery completed at rba 532.63.16, scn 2172.2647297834
Doing block recovery for file 2 block 73
Block recovery from logseq 532, block 61 to scn 9331316264745
Fri May 01 20:40:27 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 532 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\TELECOMN\REDO03.LOG
Block recovery completed at rba 532.63.16, scn 2172.2647297834
Fri May 01 20:40:27 2009
Errors in file c:\oracle\product\10.2.0\admin\telecomniuma\bdump\telecomn_smon_2864.trc:
ORA-01595: error freeing extent (10) of rollback segment (5))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [53], [51], [], [], [], [], []

Fri May 01 20:41:00 2009
Errors in file c:\oracle\product\10.2.0\admin\telecomniuma\udump\telecomn_ora_1656.trc:
ORA-00600: codice di errore interno, argomenti: [4194], [10], [10], [], [], [], [], []
ORA-00600: codice di errore interno, argomenti: [4194], [10], [10], [], [], [], [], []

Fri May 01 20:41:01 2009
Errors in file c:\oracle\product\10.2.0\admin\telecomniuma\udump\telecomn_ora_1656.trc:
ORA-00600: codice di errore interno, argomenti: [4194], [10], [10], [], [], [], [], []
ORA-00600: codice di errore interno, argomenti: [4194], [10], [10], [], [], [], [], []

Fri May 01 20:41:03 2009
Errors in file c:\oracle\product\10.2.0\admin\telecomniuma\udump\telecomn_ora_1656.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [4194], [10], [10], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [10], [10], [], [], [], [], []

Re: clone db from datafiles [message #401129 is a reply to message #401127] Fri, 01 May 2009 13:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Re: clone db from datafiles [message #401130 is a reply to message #401129] Fri, 01 May 2009 13:55 Go to previous messageGo to next message
maverick1168
Messages: 5
Registered: May 2009
Location: rome
Junior Member
you mean that is due to an oracle internal bug?

Now i try to disinstal and reinstall oracle server and i try again.

Thanks anyway.

Re: clone db from datafiles [message #401132 is a reply to message #401098] Fri, 01 May 2009 14:13 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Now i try to disinstal and reinstall oracle server and i try again.
Rarely or never does reinstall ever fix a bug since it is the same software.
Re: clone db from datafiles [message #401133 is a reply to message #401130] Fri, 01 May 2009 14:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Metalink note 39283.1, "Undo Record Number Mismatch While Adding Undo Record"

Regards
Michel
Re: clone db from datafiles [message #401201 is a reply to message #401133] Sat, 02 May 2009 08:44 Go to previous messageGo to next message
maverick1168
Messages: 5
Registered: May 2009
Location: rome
Junior Member
Hi!

After reinstallation scenario changed.

i tried to recreate control file.

Now when i startup i can reach only mount state and when i try to open:

alter database open resetlogs
*
ERRORE alla riga 1:
ORA-01152: file 1 ripristinato con un backup non sufficientemente vecchio
ORA-01110: file di dati 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\TELECOMN\SYSTEM01.DBF'

Sad

I'm afraid of patient is dead... Sad Sad
Re: clone db from datafiles [message #401203 is a reply to message #401201] Sat, 02 May 2009 09:38 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
If you do wrong operation, patients will die! Laughing
Re: clone db from datafiles [message #401207 is a reply to message #401098] Sat, 02 May 2009 10:33 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
If you do the following:
SQL> SHUTDOWN IMMEDIATE
then network copy all the necessary files to a different system but to the exact same directory locations then on new system do:
SQL> STARTUP

Oracle will not know or care it new resides on a new system.
I have done this hundreds & hundreds of times.

Since you are getting errors, then more than likely you have an error of commission. You have not copied all the needed files.
If you copy more files than you need it won't hurt; but it won't help either.

The one slight challenge is to determine which files are required.
Previous Topic: cant manually delete a data/log file in windows ?
Next Topic: how to know the DBID ?
Goto Forum:
  


Current Time: Fri Dec 09 13:58:47 CST 2016

Total time taken to generate the page: 0.11892 seconds