##########
Description:
Task: copy DB
Method: RMAN-Cloning
source Source_server:Db_Name
destination Target_server:Db_Name
port: 1540
1. Step
Please make a full backup of Db_Name db
Duration: approx. 9hrs
2. Step
Please perform an RMAN copy of DB Db_Name
Source Server/DB Source_server DB: Db_Name
Destination Server Target_server DB Db_Name; port 1540
Duration: approx: 10 hrs.
>>> as instructed we must fire the backup on source database through OS_Backup team help and start the rman duplicate active database task
@OS kindly trigger a backup as mentioned below
1. Step
Please make a full backup of Db_Name db
Duration: approx. 9hrs
OS TEAM
>> As extra backup is not possible at moment for oracle DB, hence fired total backup
OS TEAM
@ DB team backup Triggered
-rw-r--r-- 1 oracle_user dba 3424 Sep 29 00:34 dbbackup.R_201209282234_ALL_ONLI.Source_server_Db_Name_Db_Name.cmd
>>Checking whether backup is started or not!!
>>It will take some time to allocae channels.
COLUMN CLIENT_INFO FORMAT a30
COLUMN SID FORMAT 999
COLUMN SPID FORMAT 9999
SELECT s.SID, p.SPID, s.CLIENT_INFO
FROM V$PROCESS p, V$SESSION s
WHERE p.ADDR = s.PADDR
AND CLIENT_INFO LIKE 'rman%'
SID SPID CLIENT_INFO
---- ------------------------ ------------------------------
348 2162724 rman channel=BACKUP_1
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;
no rows selected
############
-> As informed by OS team rman chanel waiting for drives to start backup as of now no free drives avaliable to start backup
-> @ DB team backup completed
#############
############From Source
con Source_server
oracle_user@target_server:/home/oracle_user : sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 29 00:23:15 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
SQL> select name from v$database;
NAME
---------
Db_Name
SQL> select dbid from v$database;
DBID
----------
1653671889
SQL> select sum(bytes)/1024/1024/1024 gb from dba_data_files;
GB
----------
579.557983
SQL> set pagesize 1000
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_system_01.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_undo_01.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_sysaux_01.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_01.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micidx_01.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_tss_01.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_perfstat_01.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_fuzzydata_01.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_fuzzyidx_01.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_02.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_03.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_04.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_05.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micidx_02.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_06.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_07.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_08.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_09.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_10.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micidx_03.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_11.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_12.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_13.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_14.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micidx_04.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_15.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_16.dbf
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_micdata_17.dbf
28 rows selected.
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/cluster/Source_server/oracle/onredop/Db_Name/Db_Name_redolog_11.dbf
/cluster/Source_server/oracle/onredom/Db_Name/Db_Name_redolog_12.dbf
/cluster/Source_server/oracle/onredop/Db_Name/Db_Name_redolog_21.dbf
/cluster/Source_server/oracle/onredom/Db_Name/Db_Name_redolog_22.dbf
/cluster/Source_server/oracle/onredop/Db_Name/Db_Name_redolog_31.dbf
/cluster/Source_server/oracle/onredom/Db_Name/Db_Name_redolog_32.dbf
/cluster/Source_server/oracle/onredop/Db_Name/Db_Name_redolog_41.dbf
/cluster/Source_server/oracle/onredom/Db_Name/Db_Name_redolog_42.dbf
/cluster/Source_server/oracle/onredop/Db_Name/Db_Name_redolog_51.dbf
/cluster/Source_server/oracle/onredom/Db_Name/Db_Name_redolog_52.dbf
10 rows selected.
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
/cluster/Source_server/oracle/data1/Db_Name/Db_Name_control01.ctl
/cluster/Source_server/oracle/onredop/Db_Name/Db_Name_control02.ctl
/cluster/Source_server/oracle/onredom/Db_Name/Db_Name_control03.ctl
SQL> select * from v$tempfile;
FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED
---------- ---------------- --------- ---------- ---------- ------- ----------
BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
1 9139 12-APR-10 3 1 ONLINE READ WRITE
1.1811E+10 1441792 1.0486E+10 8192
/cluster/Source_server/oracle/temp1/Db_Name/Db_Name_temp_01.dbf
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /cluster/Source_server/oracle/offredo/Db_Name
Oldest online log sequence 62996
Next log sequence to archive 63000
Current log sequence 63000
SQL> alter database backup controlfile to trace;
Database altered.
oracle_user@target_server:/home/oracle_user : ls -lrt
-rw-r----- 1 oracle_user dba 12305 Sep 29 00:26 Db_Name_control.sql
############From target
con Target_server
oracle_user@target_server:/home/oracle_user : sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 29 00:31:18 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
SQL> select name from v$database;
NAME
---------
Db_Name
SQL> select dbid from v$database;
DBID
----------
1722710157
SQL> select sum(bytes)/1024/1024/1024 gb from dba_data_files;
GB
----------
1.46972656
SQL> set pagesize 1000
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_system01.dbf
/srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_sysaux01.dbf
/srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_undo01.dbf
/srv/cluster/Target_server/oracle/data1/Db_Name/users01.dbf
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/srv/cluster/Target_server/oracle/onredop/Db_Name/Db_Name_redo01.log
/srv/cluster/Target_server/oracle/onredom/Db_Name/Db_Name_redo01.log
/srv/cluster/Target_server/oracle/onredop/Db_Name/Db_Name_redo02.log
/srv/cluster/Target_server/oracle/onredom/Db_Name/Db_Name_redo02.log
/srv/cluster/Target_server/oracle/onredop/Db_Name/Db_Name_redo03.log
/srv/cluster/Target_server/oracle/onredom/Db_Name/Db_Name_redo03.log
6 rows selected.
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
/srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_control01.ctl
/srv/cluster/Target_server/oracle/onredop/Db_Name/Db_Name_control02.ctl
/srv/cluster/Target_server/oracle/onredom/Db_Name/Db_Name_control03.ctl
SQL> select * from v$tempfile;
FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED
---------- ---------------- --------- ---------- ---------- ------- ----------
BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
1 3200 05-JUN-12 3 1 ONLINE READ WRITE
209715200 25600 209715200 8192
/srv/cluster/Target_server/oracle/temp1/Db_Name/Db_Name_temp01.dbf
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /srv/cluster/Target_server/oracle/offredo/Db_Name
Oldest online log sequence 1160
Next log sequence to archive 1162
Current log sequence 1162
SQL> alter database backup controlfile to trace;
Database altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
oracle_user@target_server:/home/oracle_user : ls -lrt *.sql
-rw-r----- 1 ora1120 dba 8375 Sep 29 00:18 Db_Name_control.sql
SQL> sho parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /srv/oracle/product/11.2.0/dbs
/spfileDb_Name.ora
SQL> create pfile from spfile;
File created.
################
-> Edited pfile and added parameters
*.log_file_name_convert='/cluster/Source_server/oracle/onredop/Db_Name/','/srv/cluster/Target_server/oracle/onredop/Db_Name/','/cluster/Source_server/oracle/onredom/Db_Name/',/srv
/cluster/s96ic0c2/oracle/onredom/Db_Name/'
*.db_file_name_convert='/cluster/Source_server/oracle/data1/Db_Name/','/srv/cluster/Target_server/oracle/data1/Db_Name/','/cluster/Source_server/oracle/temp1/Db_Name/','/srv/clust
er/Target_server/oracle/temp1/Db_Name/'
###############
oracle_user@target_server:/srv/oracle/product/11.2.0/dbs : cat initDb_Name.ora
Db_Name.__oracle_base='/srv/oracle/product'#ORACLE_BASE set from environment
*._b_tree_bitmap_plans=FALSE
*._fix_control='8560951:ON'
*.audit_file_dest='/srv/cluster/Target_server/oracle/log/diag/rdbms/Db_Name/Db_Name/adump'
*.backup_tape_io_slaves=TRUE
*.compatible='11.2.0'
*.control_file_record_keep_time=35
*.control_files='/srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_control01.ctl','/srv/cluster/Target_server/oracle/onredop/Db_Name/Db_Name_control02.ctl','/srv/cluster/Tar
get_server/oracle/onredom/Db_Name/Db_Name_control03.ctl'
*.db_block_size=8192
*.db_cache_size=12288M
Db_Name.db_cache_size=12666798080
*.db_file_multiblock_read_count=16
*.db_keep_cache_size=8388608000
*.db_name='Db_Name'
*.diagnostic_dest='/srv/cluster/Target_server/oracle/log'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ATLASTXDB)'
*.filesystemio_options='SETALL'
*.instance_name='Db_Name'
*.java_pool_size=300M
*.job_queue_processes=10
*.large_pool_size=20971520
*.local_listener='(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_Db_Name))'
*.log_archive_dest_1='location=/srv/cluster/Target_server/oracle/offredo/Db_Name reopen=60'
*.log_archive_format='Db_Name_arch_%T_%S_%R.dbf'
*.log_buffer=14251008
*.log_checkpoint_interval=10000
*.max_dump_file_size='524288000'
*.nls_length_semantics='CHAR'
*.open_cursors=300
*.pga_aggregate_target=2048M
*.plsql_optimize_level=1
*.processes=500
*.recyclebin='OFF'
*.remote_dependencies_mode='SIGNATURE'
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=TRUE
*.session_cached_cursors=100
*.shared_pool_reserved_size=734003200
*.shared_pool_size=7532969984
Db_Name.streams_pool_size=218103808
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=4200
*.undo_tablespace='UNDO'
*.log_file_name_convert='/cluster/Source_server/oracle/onredop/Db_Name/','/srv/cluster/Target_server/oracle/onredop/Db_Name/','/cluster/Source_server/oracle/onredom/Db_Name/','/sr
v/cluster/s96ic0c2/oracle/onredom/Db_Name/'
*.db_file_name_convert='/cluster/Source_server/oracle/data1/Db_Name/','/srv/cluster/Target_server/oracle/data1/Db_Name/','/cluster/Source_server/oracle/temp1/Db_Name/','/srv/clust
er/Target_server/oracle/temp1/Db_Name/'
################
-> Copy password file from source to target DB
################
SQL> shut immediate
Database closed.
Database dismounted.
->Startup nomount using the modified pfile
#####Check Network From Source to target
oracle_user@target_server:/home/oracle_user : tnsping Db_Name_t
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 29-SEP-2012 01:36:34
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
/oracle/product/11.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=53.31.33.32)(Port=1540))(CONNECT_DATA=(SID=Db_Name)))
OK (10 msec)
------------------
oracle_user@target_server:/home/oracle_user : ls -lrt *.rcv
-rw-r--r-- 1 oracle_user dba 179 Sep 22 10:41 rman.rcv
oracle_user@target_server:/home/oracle_user : cat rman.rcv
connect target
connect auxiliary
sys/copy@targetdb_t
run
{
DUPLICATE TARGET DATABASE TO target_db FROM ACTIVE DATABASE NOFILENAMECHECK;
}
->nohup rman cmdfile=rman.rcv log=rman_29082012.log &
connected to target database: Db_Name (DBID=1653671889)
connected to auxiliary database: Db_Name (not mounted)
Starting Duplicate Db at 29-SEP-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=345 device type=DISK
contents of Memory Script:
{
sql clone "alter system set db_name =
''Db_Name'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''Db_Name'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format '/srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_control01.ctl';
restore clone controlfile to '/srv/cluster/Target_server/oracle/onredop/Db_Name/Db_Name_control02.ctl' from
'/srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_control01.ctl';
restore clone controlfile to '/srv/cluster/Target_server/oracle/onredom/Db_Name/Db_Name_control03.ctl' from
'/srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_control01.ctl';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''Db_Name'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''Db_Name'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 29597396992 bytes
Fixed Size 2235720 bytes
Variable Size 8455717560 bytes
Database Buffers 21072183296 bytes
Redo Buffers 67260416 bytes
Starting backup at 29-SEP-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=764 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/oracle/product/11.2.0/dbs/snapcf_Db_Name.f tag=TAG20120929T123716 RECID=597 STAMP=795271038
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 29-SEP-12
Starting restore at 29-SEP-12
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=296 device type=DISK
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 29-SEP-12
-> From Log
Total System Global Area 29597396992 bytes
Fixed Size 2235720 bytes
Variable Size 8455717560 bytes
Database Buffers 21072183296 bytes
Redo Buffers 67260416 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''Db_Name'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
}
executing Memory Script
sql statement: alter system set db_name = ''Db_Name'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/29/2012 21:20:15
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 63073 and starting SCN of 12136493195
Recovery Manager complete.
>>Restore finished with error
>>Restore completed but recovery failed as some archive files missing in source moved to TSM
>> Recreate controlfile on target from trace of controlfile
>>Manually recover some archive logs
SQL> recover database using backup controlfile;
ORA-00279: change 12136493450 generated at 09/29/2012 12:37:42 needed for
thread 1
ORA-00289: suggestion :
/srv/cluster/Target_server/oracle/offredo/Db_Name/Db_Name_arch_0001_0000063073_071613
8001.dbf
ORA-00280: change 12136493450 for thread 1 is in sequence #63073
Specify log: {
=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/srv/cluster/Target_server/oracle/offredo/Db_Name/Db_Name_arch_0001_0000063073_07161
38001.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
SQL> alter database open resetlogs;
Database altered.
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
Db_Name READ WRITE
SQL> select dbid from v$database;
DBID
----------
1653671889
SQL> select * from v$tempfile;
no rows selected
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/srv/cluster/Target_server/oracle/temp1/Db_Name/Db_Name_temp01.dbf' SIZE 209715200 REUSE AUTOEXTEND OFF;
Tablespace altered.
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
Db_Name READ WRITE
SQL> select * from v$tempfile;
FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED
---------- ---------------- --------- ---------- ---------- ------- ----------
BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
---------- ---------- ------------ ----------
NAME
--------------------------------------------------------------------------------
1 1.2138E+10 29-SEP-12 3 1 ONLINE READ WRITE
209715200 25600 209715200 8192
/srv/cluster/Target_server/oracle/temp1/Db_Name/Db_Name_temp01.dbf
SQL> select * from dba_temp_files;
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- -------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
/srv/cluster/Target_server/oracle/temp1/Db_Name/Db_Name_temp01.dbf
1 TEMP 209715200 25600 ONLINE
1 NO 0 0 0 208666624 25472
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2.9597E+10 bytes
Fixed Size 2235720 bytes
Variable Size 8455717560 bytes
Database Buffers 2.1072E+10 bytes
Redo Buffers 67260416 bytes
Database mounted.
SQL> exit
-> Change Dbid of target db
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
oracle_user@target_server:/home/oracle_user : echo $ORACLE_SID
Db_Name
oracle_user@target_server:/home/oracle_user : nid target=sys
DBNEWID: Release 11.2.0.3.0 - Production on Sat Sep 29 22:42:50 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to database Db_Name (DBID=1653671889)
Connected to server version 11.2.0
Control Files in database:
/srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_control01.ctl
/srv/cluster/Target_server/oracle/onredop/Db_Name/Db_Name_control02.ctl
/srv/cluster/Target_server/oracle/onredom/Db_Name/Db_Name_control03.ctl
Change database ID of database Db_Name? (Y/[N]) => y
Proceeding with operation
Changing database ID from 1653671889 to 1732839225
Control File /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_control01.ctl - modified
Control File /srv/cluster/Target_server/oracle/onredop/Db_Name/Db_Name_control02.ctl - modified
Control File /srv/cluster/Target_server/oracle/onredom/Db_Name/Db_Name_control03.ctl - modified
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_system_01.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_undo_01.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_sysaux_01.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_01.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micidx_01.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_tss_01.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_perfstat_01.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_fuzzydata_01.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_fuzzyidx_01.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_02.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_03.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_04.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_05.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micidx_02.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_06.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_07.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_08.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_09.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_10.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micidx_03.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_11.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_12.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_13.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_14.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micidx_04.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_15.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_16.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_micdata_17.db - dbid changed
Datafile /srv/cluster/Target_server/oracle/temp1/Db_Name/Db_Name_temp01.db - dbid changed
Control File /srv/cluster/Target_server/oracle/data1/Db_Name/Db_Name_control01.ctl - dbid changed
Control File /srv/cluster/Target_server/oracle/onredop/Db_Name/Db_Name_control02.ctl - dbid changed
Control File /srv/cluster/Target_server/oracle/onredom/Db_Name/Db_Name_control03.ctl - dbid changed
Instance shut down
Database ID for database Db_Name changed to 1732839225.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database ID.
DBNEWID - Completed succesfully.
oracle_user@target_server:/home/oracle_user : sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 29 22:43:52 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> startup mount
ORACLE instance started.
Total System Global Area 2.9597E+10 bytes
Fixed Size 2235720 bytes
Variable Size 8455717560 bytes
Database Buffers 2.1072E+10 bytes
Redo Buffers 67260416 bytes
Database mounted.
SQL> alter database open RESETLOGS;
Database altered.
SQL> select dbid from v$database;
DBID
----------
1732839225
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 Db_Name
target_server
11.2.0.3.0 29-SEP-12 OPEN NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
Db_Name READ WRITE
SQL> select * from v$recover_file;
no rows selected
SQL> select sum(bytes)/1024/1024/1024 from v$datafile;
SUM(BYTES)/1024/1024/1024
-------------------------
579.557983
-> Create spfile on target db and restart the target db
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /srv/oracle/product/11.2.0/dbs
/spfileDb_Name.ora
->Active database clone using Rman complete
