Mallik034: DR database or Standby database build is very easy

DR database or Standby database build is very easy:

Primary:

DB: ORCL

OH: /u01/app/oracle/product/19.0.0.0/dbhome_1

Hostname: oracledb.localdomain.com

Standby:

DB: ORCLSB

OH: /u01/app/oracle/product/19.0.0.0/dbhome_1

Hostname: oraclesb.localdomain.com

High Level Steps:

1. Prechecks on primary and Standby Servers:

2. Check listener.ora and tnsnames.ora on primary and Standby Servers:

3. Verify tnsping on primary and Standby Servers:

4. Copy Primary password file to standby:

5. Create standby init/pfile and start the standby instance in nomount mode:

6. Verify password connectivity for both Primary and standby:

7. Set the standby parameters at Primary and standby redologs:

8. Take Primary database backup:

9. Build Standby database:

10. Enable log shipping:

11. Verify the Primary and Standby sync status:

1. Prechecks on primary and Standby Servers:

Primary:

ps -ef|grep smon

hostname -f

Standby:

ps -ef|grep smon

hostname -f

Primary:

. oraenv

ORCL

/u01/app/oracle/product/19.0.0.0/dbhome_1

env |grep ORA

sqlplus / as sysdba

archive log list

select FORCE_LOGGING,log_mode from v$database;

2. Check listener.ora and tnsnames.ora on primary and Standby Servers:

Primary:

cd $ORACLE_HOME/network/admin

cat listener.ora

cat tnsnames.ora

lsnrctl status LISTENER_ORCL

lsnrctl start LISTENER_ORCL

Standby:

. oraenv

ORCLSB

/u01/app/oracle/product/19.0.0.0/dbhome_1

cd $ORACLE_HOME/network/admin

cat listener.ora

cat tnsnames.ora

lsnrctl status LISTENER_ORCLSB

lsnrctl start LISTENER_ORCLSB

3. Verify tnsping on primary and Standby Servers:

Primary:

tnsping ORCL

tnsping ORCLSB

Standby:

tnsping ORCL

tnsping ORCLSB

4. Copy Primary password file to standby:

Primary:

cd $ORACLE_HOME/dbs

ls -ltr orapwORCL

scp orapwORCL oracle@standbyserver:/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/orapwORCLSB

Standby:

cd $ORACLE_HOME/dbs

ls -l orapwORCLSB

5. Create standby init/pfile and start the standby instance in nomount mode:

Standby:

cat initORCLSB.ora

db_name=ORCL

db_unique_name=ORCLSB

. oraenv

ORCLSB

/u01/app/oracle/product/19.0.0.0/dbhome_1

env |grep ORA

sqlplus / as sysdba

startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initORCLSB.ora';

6. Verify password connectivity for both Primary and standby:

Primary:

sqlplus sys/Mallik123@ORCL as sysdba

select instance_name, status from v$instance;

sqlplus sys/Mallik123@ORCLSB as sysdba

select instance_name, status from v$instance;

Standby:

sqlplus sys/Mallik123@ORCL as sysdba

select instance_name, status from v$instance;

sqlplus sys/Mallik123@ORCLSB as sysdba

select instance_name, status from v$instance;

7. Set the standby parameters at Primary and standby redologs:

Primary:

ALTER SYSTEM SET db_unique_name='ORCL' SCOPE=SPFILE;

ALTER SYSTEM SET log_archive_config='dg_config=(ORCL,ORCLSB)' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_dest_1='location=use_db_recovery_file_dest' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=ORCL' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_dest_2='service=ORCLSB async valid_for=(online_logfiles,primary_role) db_unique_name=ORCLSB' SCOPE=both;

ALTER SYSTEM SET fal_server='ORCLSB' SCOPE=SPFILE;

ALTER SYSTEM SET fal_client='ORCL' SCOPE=SPFILE;

ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=SPFILE;

ALTER SYSTEM SET db_file_name_convert='/u01/app/oracle/oradata/ORCL/datafile','/u01/app/oracle/oradata/ORCLSB/datafile' SCOPE=SPFILE;

ALTER SYSTEM SET log_file_name_convert='/u01/app/oracle/oradata/ORCL/onlinelog','/u01/app/oracle/oradata/ORCLSB/onlinelog','/u01/app/oracle/fast_recovery_area/ORCL/onlinelog','/u01/app/oracle/fast_recovery_area/ORCLSB/onlinelog' SCOPE=SPFILE;

show parameter db_unique_name

show parameter log_archive_config

show parameter log_archive_dest_1

show parameter log_archive_dest_2

show parameter fal

show parameter standby_file_management

show parameter db_file_name_convert

show parameter log_file_name_convert

set pages 1000

set lines 1000

col INSTANCE for a10

col member for a75

SELECT t.INSTANCE, l.THREAD#, l.GROUP#, l.SEQUENCE#, l.bytes, l.archived, l.status, lf.MEMBER

FROM v$log l, v$logfile lf, v$thread t

WHERE t.THREAD# = l.THREAD#

AND l.GROUP# = lf.GROUP#

ORDER BY l.THREAD#, GROUP#;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 4 ('/u01/app/oracle/oradata/ORCL/onlinelog/standby_redo01.log','/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/standby_redo01_1.log') SIZE 200M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 5 ('/u01/app/oracle/oradata/ORCL/onlinelog/standby_redo02.log','/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/standby_redo02_2.log') SIZE 200M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 6 ('/u01/app/oracle/oradata/ORCL/onlinelog/standby_redo03.log','/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/standby_redo03_3.log') SIZE 200M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 7 ('/u01/app/oracle/oradata/ORCL/onlinelog/standby_redo04.log','/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/standby_redo04_4.log') SIZE 200M;

set pages 1000

set lines 1000

col DBID for a10

select * from v$standby_log;

8. Take Primary database backup:

Primary:

rman target /

run {

allocate channel ch1 device type disk;

allocate channel ch2 device type disk;

crosscheck backup;

crosscheck archivelog all;

DELETE noprompt archivelog all COMPLETED BEFORE 'SYSDATE-7';

backup as backupset incremental level 0 database format '/u01/backup/Fullback_%T_%U'

plus archivelog format '/u01/backup/Archive_%T_%U';

backup current controlfile format '/u01/backup/Controlback_%T_%U';

release channel ch1;

release channel ch2;

}

cd /u01/backup

ls -l

scp * oracle@10.38.4.118:/u01/backup/

Standby:

cd /u01/backup

ls -l

9. Build Standby database:

Option1:

standby build using active database duplication with backup

rman target sys/Mallik123@ORCL

connect auxiliary sys/Mallik123@ORCLSB

run

{

allocate channel p1 type disk;

allocate channel p2 type disk;

allocate channel p3 type disk;

allocate channel p4 type disk;

allocate auxiliary channel s1 type disk;

allocate auxiliary channel s2 type disk;

allocate auxiliary channel s3 type disk;

allocate auxiliary channel s4 type disk;

duplicate target database for standby from active database

spfile

parameter_value_convert 'ORCL','ORCLSB'

set db_name='ORCL'

set db_unique_name='ORCLSB'

set db_file_name_convert '/u01/app/oracle/oradata/ORCL/datafile','/u01/app/oracle/oradata/ORCLSB/datafile'

set log_file_name_convert='/u01/app/oracle/oradata/ORCL/onlinelog','/u01/app/oracle/oradata/ORCLSB/onlinelog','/u01/app/oracle/fast_recovery_area/ORCL/onlinelog','/u01/app/oracle/fast_recovery_area/ORCLSB/onlinelog'

;

}

Option2:

standby build using backup based database duplication

rman auxiliary sys/Mallik123@ORCLSB

run

{

allocate auxiliary channel s1 type disk;

allocate auxiliary channel s2 type disk;

allocate auxiliary channel s3 type disk;

allocate auxiliary channel s4 type disk;

DUPLICATE TARGET DATABASE FOR STANDBY

SPFILE

parameter_value_convert 'ORCL','ORCLSB'

set db_name='ORCL'

set db_unique_name='ORCLSB'

set db_file_name_convert '/u01/app/oracle/oradata/ORCL/datafile','/u01/app/oracle/oradata/ORCLSB/datafile'

BACKUP LOCATION '/u01/backup/' nofilenamecheck

;

}

10. Enable log shipping

sqlplus / as sysdba

SELECT name,database_role FROM v$database;

show parameter fal

alter system set fal_server=ORCL scope=both;

show parameter fal

Start mrp:

Standby:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session; --- arc/mrp apply

alter database recover managed standby database using current logfile disconnect from session; --- real time apply

alter database recover managed standby database cancel;

SELECT sequence#, first_time, next_time, applied FROM v$archived_log where sequence#>=6770;

Primary:

alter system set log_archive_dest_state_2=DEFER scope=both sid='*';

alter system set log_archive_dest_state_2=enable scope=both sid='*';

11. Verify the Primary and Standby sync status:

Primary:

archive log list;

alter system switch logfile;

SELECT sequence#, first_time, next_time, applied FROM v$archived_log where sequence#>=6370;

Standby:

sqlplus / as sysdba

SELECT sequence#, first_time, next_time, applied FROM v$archived_log where sequence#>=6370;

log:

[oracle@oracledb archivelog]$ ps -ef|grep smon

oracle 22431 1 0 23:09 ? 00:00:00 ora_smon_ORCL

oracle 24508 19837 0 23:14 pts/1 00:00:00 grep --color=auto smon

[oracle@oracledb archivelog]$

[oracle@oracledb archivelog]$ hostname

oracledb.localdomain.com

[oracle@oracledb archivelog]$

[oracle@oraclesb onlinelog]$ ps -ef|grep smon

oracle 7608 6665 0 23:16 pts/1 00:00:00 grep --color=auto smon

[oracle@oraclesb onlinelog]$

[oracle@oraclesb onlinelog]$ hostname -f

oraclesb.localdomain.com

[oracle@oraclesb onlinelog]$

[oracle@oracledb admin]$ env |grep ORA

ORACLE_SID=ORCL

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

[oracle@oracledb admin]$

[oracle@oracledb archivelog]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 13 23:15:00 2022

Version 19.11.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 5970

Next log sequence to archive 5970

Current log sequence 5972

SQL>

SQL> select FORCE_LOGGING,log_mode from v$database;

FORCE_LOGGING LOG_MODE

--------------------------------------- ------------

YES ARCHIVELOG

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

[oracle@oracledb archivelog]$

[oracle@oracledb archivelog]$ cd $ORACLE_HOME/network/admin

[oracle@oracledb admin]$ pwd

/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin

[oracle@oracledb admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

ADR_BASE_LISTENER_ORCL = /u01/app/oracle

LISTENER_ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oracledb.localdomain.com)(PORT = 1522))

)

[oracle@oracledb admin]$ cat tnsnames.ora

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oracledb.localdomain.com)(PORT = 1522))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ORCL)

)

ORCLSB =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = oraclesb.localdomain.com)(PORT = 1522))

)

(CONNECT_DATA =

(SERVICE_NAME = ORCLSB)

)

[oracle@oracledb admin]$

[oracle@oracledb admin]$ lsnrctl status LISTENER_ORCL

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 13-AUG-2022 23:16:17

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracledb.localdomain.com)(PORT=1522)))

STATUS of the LISTENER

------------------------

Alias LISTENER_ORCL

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 20-JAN-2022 09:46:47

Uptime 205 days 13 hr. 29 min. 30 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/oracledb/listener_orcl/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracledb.localdomain.com)(PORT=1522)))

Services Summary...

Service "ORCL" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "ORCLXDB" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@oracledb admin]$

[oracle@oraclesb admin]$ ps -ef|grep tns

root 35 2 0 Jul05 ? 00:00:00 [netns]

oracle 4871 1 0 Aug04 ? 00:00:12 /u01/app/oracle/product/19.0.0.0/dbhome_1/bin/tnslsnr LISTENER_ORCLSB -inherit

oracle 7804 6665 0 23:19 pts/1 00:00:00 grep --color=auto tns

[oracle@oraclesb admin]$

[oracle@oraclesb onlinelog]$ cd $ORACLE_HOME/network/admin

[oracle@oraclesb admin]$

[oracle@oraclesb admin]$ pwd

/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin

[oracle@oraclesb admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER_ORCLSB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oraclesb.localdomain.com)(PORT = 1522))

)

ADR_BASE_LISTENER_ORCLSB = /u01/app/oracle

SID_LIST_LISTENER_ORCLSB =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = ORCLSB)

(ORACLE_HOME = /u01/app/oracle/product/19.0.0.0/dbhome_1)

(SID_NAME = ORCLSB)

)

[oracle@oraclesb admin]$

[oracle@oraclesb admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORCLSB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oraclesb.localdomain.com)(PORT = 1522))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ORCLSB)

)

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = oracledb.localdomain.com)(PORT = 1522))

)

(CONNECT_DATA =

(SERVICE_NAME = ORCL)

)

[oracle@oraclesb admin]$

[oracle@oraclesb admin]$ lsnrctl status LISTENER_ORCLSB

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 13-AUG-2022 23:19:50

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclesb.localdomain.com)(PORT=1522)))

STATUS of the LISTENER

------------------------

Alias LISTENER_ORCLSB

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 04-AUG-2022 09:17:05

Uptime 9 days 14 hr. 2 min. 44 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/oraclesb/listener_orclsb/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraclesb.localdomain.com)(PORT=1522)))

Services Summary...

Service "ORCLSB" has 1 instance(s).

Instance "ORCLSB", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@oraclesb admin]$

[oracle@oracledb admin]$ tnsping ORCL

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 13-AUG-2022 23:18:05

Used parameter files:

/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracledb.localdomain.com)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL)))

OK (0 msec)

[oracle@oracledb admin]$

[oracle@oracledb admin]$ tnsping ORCLSB

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 13-AUG-2022 23:18:09

Used parameter files:

/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oraclesb.localdomain.com)(PORT = 1522))) (CONNECT_DATA = (SERVICE_NAME = ORCLSB)))

OK (10 msec)

[oracle@oracledb admin]$

[oracle@oracledb admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 13 23:18:29 2022

Version 19.11.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

SQL> show parameter local

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

local_listener string (ADDRESS = (PROTOCOL = TCP)(HO

ST = oracledb.localdomain.com)

(PORT = 1522))

parallel_force_local boolean FALSE

SQL>

[oracle@oracledb admin]$ cd $ORACLE_HOME/dbs

[oracle@oracledb dbs]$ pwd

/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs

[oracle@oracledb dbs]$ ls -ltr orapw*

-rw-r-----. 1 oracle oinstall 2048 Aug 2 2021 orapwORCL

[oracle@oracledb dbs]$

[oracle@oraclesb admin]$ cd $ORACLE_HOME/dbs

[oracle@oraclesb dbs]$ pwd

/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs

[oracle@oraclesb dbs]$ ls -l orapw*

-rw-r-----. 1 oracle oinstall 2048 Aug 4 10:17 orapwORCLSB

[oracle@oraclesb dbs]$

[oracle@oraclesb dbs]$ cat initORCLSB.ora

db_name=ORCL

db_unique_name=ORCLSB

[oracle@oraclesb dbs]$

[oracle@oraclesb dbs]$ . oraenv

ORACLE_SID = [ORCLSB] ?

The Oracle base remains unchanged with value /u01/app/oracle

[oracle@oraclesb dbs]$ env |grep ORA

ORACLE_SID=ORCLSB

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1

[oracle@oraclesb dbs]$

[oracle@oraclesb dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 13 23:23:54 2022

Version 19.11.0.0.0

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initORCLSB.ora';

ORACLE instance started.

Total System Global Area 322960856 bytes

Fixed Size 8895960 bytes

Variable Size 239075328 bytes

Database Buffers 67108864 bytes

Redo Buffers 7880704 bytes

SQL>

[oracle@oraclesb dbs]$ tnsping ORCL

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 13-AUG-2022 23:24:50

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oracledb.localdomain.com)(PORT = 1522))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))

OK (0 msec)

[oracle@oraclesb dbs]$ tnsping ORCLSB

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 13-AUG-2022 23:24:53

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraclesb.localdomain.com)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCLSB)))

OK (0 msec)

[oracle@oraclesb dbs]$

[oracle@oracledb dbs]$ sqlplus sys/Mallik123@ORCL as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 13 23:22:50 2022

Version 19.11.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

SQL> select instance_name, status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

ORCL OPEN

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

[oracle@oracledb dbs]$ sqlplus sys/Mallik123@ORCLSB as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 13 23:23:14 2022

Version 19.11.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

SQL> select instance_name, status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

ORCLSB STARTED

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

[oracle@oracledb dbs]$

[oracle@oraclesb dbs]$ sqlplus sys/Mallik123@ORCL as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 13 23:25:51 2022

Version 19.11.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

SQL> select instance_name, status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

ORCL OPEN

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

[oracle@oraclesb dbs]$ sqlplus sys/Mallik123@ORCLSB as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 13 23:26:05 2022

Version 19.11.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

SQL> select instance_name, status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

ORCLSB STARTED

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

[oracle@oraclesb dbs]$

[oracle@oracledb dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 13 23:24:32 2022

Version 19.11.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.11.0.0.0

SQL> show parameter db_unique_name

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_unique_name string ORCL

SQL> show parameter log_archive_config

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_config string dg_config=(ORCL,ORCLSB)

SQL> show parameter log_archive_dest_1

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_1 string location=use_db_recovery_file_

dest

log_archive_dest_10 string

log_archive_dest_11 string

log_archive_dest_12 string

log_archive_dest_13 string

log_archive_dest_14 string

log_archive_dest_15 string

log_archive_dest_16 string

log_archive_dest_17 string

log_archive_dest_18 string

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_19 string

SQL> show parameter log_archive_dest_2

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_2 string service=ORCLSB async valid_for

=(online_logfiles,primary_role

) db_unique_name=ORCLSB

log_archive_dest_20 string

log_archive_dest_21 string

log_archive_dest_22 string

log_archive_dest_23 string

log_archive_dest_24 string

log_archive_dest_25 string

log_archive_dest_26 string

log_archive_dest_27 string

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_28 string

log_archive_dest_29 string

SQL> show parameter fal

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

fal_client string ORCL

fal_server string ORCLSB

SQL> show parameter standby_file_management

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

standby_file_management string AUTO

SQL> show parameter db_file_name_convert

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_file_name_convert string /u01/app/oracle/oradata/ORCL/d

atafile, /u01/app/oracle/orada

ta/ORCLSB/datafile

pdb_file_name_convert string

SQL> show parameter log_file_name_convert

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_file_name_convert string /u01/app/oracle/oradata/ORCL/o

nlinelog, /u01/app/oracle/orad

ata/ORCLSB/onlinelog, /u01/app

/oracle/fast_recovery_area/ORC

L/onlinelog, /u01/app/oracle/f

ast_recovery_area/ORCLSB/onlin

elog

SQL>

ALTER SYSTEM SET db_unique_name='ORCL' SCOPE=SPFILE;

ALTER SYSTEM SET log_archive_config='dg_config=(ORCL,ORCLSB)' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_dest_1='location=use_db_recovery_file_dest' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=ORCL' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_dest_2='service=ORCLSB async valid_for=(online_logfiles,primary_role) db_unique_name=ORCLSB' SCOPE=both;

ALTER SYSTEM SET fal_server='ORCLSB' SCOPE=SPFILE;

ALTER SYSTEM SET fal_client='ORCL' SCOPE=SPFILE;

ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=SPFILE;

ALTER SYSTEM SET db_file_name_convert='/u01/app/oracle/oradata/ORCL/datafile','/u01/app/oracle/oradata/ORCLSB/datafile' SCOPE=SPFILE;

SQL> set pages 1000

set lines 1000

col INSTANCE for a10

SQL> SQL> SQL> col member for a75

SQL> SELECT t.INSTANCE, l.THREAD#, l.GROUP#, l.SEQUENCE#, l.bytes, l.archived, l.status, lf.MEMBER

2 FROM v$log l, v$logfile lf, v$thread t

3 WHERE t.THREAD# = l.THREAD#

4 AND l.GROUP# = lf.GROUP#

5 ORDER BY l.THREAD#, GROUP#;

INSTANCE THREAD# GROUP# SEQUENCE# BYTES ARC STATUS MEMBER

---------- ---------- ---------- ---------- ---------- --- ---------------- ---------------------------------------------------------------------------

ORCL 1 1 5971 209715200 NO INACTIVE /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_1_k90p82vd_.log

ORCL 1 1 5971 209715200 NO INACTIVE /u01/app/oracle/fast_recovery_area/ORCL/onlinelog/o1_mf_1_k90p8306_.log

ORCL 1 2 5972 209715200 NO CURRENT /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_k90p84vy_.log

ORCL 1 2 5972 209715200 NO CURRENT /u01/app/oracle/fast_recovery_area/ORCL/onlinelog/o1_mf_2_k90p850w_.log

ORCL 1 3 5970 209715200 NO INACTIVE /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_k90p8704_.log

ORCL 1 3 5970 209715200 NO INACTIVE /u01/app/oracle/fast_recovery_area/ORCL/onlinelog/o1_mf_3_k90p8749_.log

6 rows selected.

SQL>

SQL> set pages 1000

set lines 1000

col DBID for a10

select * from v$standby_log;SQL> SQL> SQL>

GROUP# DBID THREAD# SEQUENCE# BYTES BLOCKSIZE USED ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME LAST_CHANGE# LAST_TIME CON_ID

---------- ---------- ---------- ---------- ---------- ---------- ---------- --- ---------- ------------- --------- ------------ --------- ------------ --------- ----------

4 UNASSIGNED 1 0 209715200 512 0 YES UNASSIGNED 0

5 UNASSIGNED 1 0 209715200 512 0 YES UNASSIGNED 0

6 UNASSIGNED 1 0 209715200 512 0 YES UNASSIGNED 0

7 UNASSIGNED 1 0 209715200 512 0 YES UNASSIGNED 0

SQL>

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 4 ('/u01/app/oracle/oradata/ORCL/onlinelog/standby_redo01.log','/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/standby_redo01_1.log') SIZE 200M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 5 ('/u01/app/oracle/oradata/ORCL/onlinelog/standby_redo02.log','/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/standby_redo02_2.log') SIZE 200M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 6 ('/u01/app/oracle/oradata/ORCL/onlinelog/standby_redo03.log','/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/standby_redo03_3.log') SIZE 200M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 7 ('/u01/app/oracle/oradata/ORCL/onlinelog/standby_redo04.log','/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/standby_redo04_4.log') SIZE 200M;

Backup:

rman target /

run {

allocate channel ch1 device type disk;

allocate channel ch2 device type disk;

crosscheck backup;

crosscheck archivelog all;

DELETE noprompt archivelog all COMPLETED BEFORE 'SYSDATE-7';

backup as backupset incremental level 0 database format '/u01/backup/Fullback_%T_%U'

plus archivelog format '/u01/backup/Archive_%T_%U';

backup current controlfile format '/u01/backup/Controlback_%T_%U';

release channel ch1;

release channel ch2;

}

[oracle@oracledb backup]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sat Aug 13 23:51:14 2022

Version 19.11.0.0.0

connected to target database: ORCL (DBID=1607315920)

RMAN> run {

2> allocate channel ch1 device type disk;

3> allocate channel ch2 device type disk;

4> crosscheck backup;

crosscheck archivelog all;

5> 6> DELETE noprompt archivelog all COMPLETED BEFORE 'SYSDATE-7';

backup as backupset incremental level 0 database format '/u01/backup/Fullback_%T_%U'

7> plus archivelog format '/u01/backup/Archive_%T_%U';

backup current controlfile format '/u01/backup/Controlback_%T_%U';

8> 9> release channel ch1;

10> 11> release channel ch2;

}12>

using target database control file instead of recovery catalog

allocated channel: ch1

channel ch1: SID=269 device type=DISK

allocated channel: ch2

channel ch2: SID=393 device type=DISK

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/tmp/ForStandby_gd14d0jl_10765_1_1 RECID=10038 STAMP=1111917174

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/tmp/ForStandby_ge14d0jp_10766_1_1 RECID=10039 STAMP=1111917178

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2022_08_05/o1_mf_s_1111917388_kgs6zo2y_.bkp RECID=10040 STAMP=1111917389

Crosschecked 2 objects

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2022_08_13/o1_mf_s_1112658521_khhtr1n5_.bkp RECID=10071 STAMP=1112658521

Crosschecked 2 objects

validation succeeded for archived log

archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2022_08_13/o1_mf_1_5970_khhtgr0x_.arc RECID=1864 STAMP=1112658224

validation succeeded for archived log

archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2022_08_13/o1_mf_1_5971_khhtdynh_.arc RECID=1863 STAMP=1112658166

validation succeeded for archived log

archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2022_08_13/o1_mf_1_5972_khhtgr2w_.arc RECID=1865 STAMP=1112658224

validation succeeded for archived log

archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2022_08_13/o1_mf_1_5973_khhtljgg_.arc RECID=1866 STAMP=1112658344

validation succeeded for archived log

archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2022_08_13/o1_mf_1_5974_khhtqf1t_.arc RECID=1867 STAMP=1112658501

Crosschecked 3 objects

validation succeeded for archived log

archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2022_08_13/o1_mf_1_5975_khhtqz0c_.arc RECID=1868 STAMP=1112658519

Crosschecked 3 objects

Starting backup at 13-AUG-22

current log archived

channel ch1: starting archived log backup set

channel ch1: specifying archived log(s) in backup set

input archived log thread=1 sequence=5970 RECID=1864 STAMP=1112658224

input archived log thread=1 sequence=5971 RECID=1863 STAMP=1112658166

input archived log thread=1 sequence=5972 RECID=1865 STAMP=1112658224

input archived log thread=1 sequence=5973 RECID=1866 STAMP=1112658344

channel ch1: starting piece 1 at 13-AUG-22

channel ch2: starting archived log backup set

channel ch2: specifying archived log(s) in backup set

input archived log thread=1 sequence=5974 RECID=1867 STAMP=1112658501

input archived log thread=1 sequence=5975 RECID=1868 STAMP=1112658519

input archived log thread=1 sequence=5976 RECID=1869 STAMP=1112658688

channel ch2: starting piece 1 at 13-AUG-22

channel ch1: finished piece 1 at 13-AUG-22

piece handle=/u01/backup/Archive_20220813_hm153ko0_10806_1_1 tag=TAG20220813T235128 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:01

channel ch2: finished piece 1 at 13-AUG-22

piece handle=/u01/backup/Archive_20220813_hn153ko0_10807_1_1 tag=TAG20220813T235128 comment=NONE

channel ch2: backup set complete, elapsed time: 00:00:01

Finished backup at 13-AUG-22

Starting backup at 13-AUG-22

channel ch1: starting incremental level 0 datafile backup set

channel ch1: specifying datafile(s) in backup set

input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_k3jps1mq_.dbf

input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_k3jpsjp6_.dbf

channel ch1: starting piece 1 at 13-AUG-22

channel ch2: starting incremental level 0 datafile backup set

channel ch2: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_k3jprllp_.dbf

input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_k3jpsqnf_.dbf

channel ch2: starting piece 1 at 13-AUG-22

channel ch1: finished piece 1 at 13-AUG-22

piece handle=/u01/backup/Fullback_20220813_ho153ko1_10808_1_1 tag=TAG20220813T235129 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:15

channel ch1: starting incremental level 0 datafile backup set

channel ch1: specifying datafile(s) in backup set

input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL/datafile/test_16k_ts01.dbf

channel ch1: starting piece 1 at 13-AUG-22

channel ch2: finished piece 1 at 13-AUG-22

piece handle=/u01/backup/Fullback_20220813_hp153ko1_10809_1_1 tag=TAG20220813T235129 comment=NONE

channel ch2: backup set complete, elapsed time: 00:00:15

channel ch1: finished piece 1 at 13-AUG-22

piece handle=/u01/backup/Fullback_20220813_hq153kog_10810_1_1 tag=TAG20220813T235129 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:01

Finished backup at 13-AUG-22

Starting backup at 13-AUG-22

current log archived

channel ch1: starting archived log backup set

channel ch1: specifying archived log(s) in backup set

input archived log thread=1 sequence=5977 RECID=1870 STAMP=1112658706

channel ch1: starting piece 1 at 13-AUG-22

channel ch1: finished piece 1 at 13-AUG-22

piece handle=/u01/backup/Archive_20220813_hr153koi_10811_1_1 tag=TAG20220813T235146 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:01

Finished backup at 13-AUG-22

Starting backup at 13-AUG-22

channel ch1: starting datafile copy

copying current control file

output file name=/u01/backup/Controlback_20220813_cf_D-ORCL_id-1607315920_hs153koj tag=TAG20220813T235147 RECID=970 STAMP=1112658707

channel ch1: datafile copy complete, elapsed time: 00:00:01

Finished backup at 13-AUG-22

Starting Control File and SPFILE Autobackup at 13-AUG-22

piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2022_08_13/o1_mf_s_1112658708_khhtxwly_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 13-AUG-22

released channel: ch1

released channel: ch2

RMAN> exit

Recovery Manager complete.

[oracle@oracledb backup]$ pwd

/u01/backup

[oracle@oracledb backup]$ ll

total 2281296

-rw-r-----. 1 oracle oinstall 48598528 Aug 13 23:51 Archive_20220813_hm153ko0_10806_1_1

-rw-r-----. 1 oracle oinstall 20655104 Aug 13 23:51 Archive_20220813_hn153ko0_10807_1_1

-rw-r-----. 1 oracle oinstall 13824 Aug 13 23:51 Archive_20220813_hr153koi_10811_1_1

-rw-r-----. 1 oracle oinstall 26034176 Aug 13 23:51 Controlback_20220813_cf_D-ORCL_id-1607315920_hs153koj

-rw-r-----. 1 oracle oinstall 1298079744 Aug 13 23:51 Fullback_20220813_ho153ko1_10808_1_1

-rw-r-----. 1 oracle oinstall 942481408 Aug 13 23:51 Fullback_20220813_hp153ko1_10809_1_1

-rw-r-----. 1 oracle oinstall 180224 Aug 13 23:51 Fullback_20220813_hq153kog_10810_1_1

[oracle@oracledb backup]$

[oracle@oracledb backup]$ scp * oracle@10.38.4.118:/u01/backup/

oracle@10.38.4.118's password:

Archive_20220813_hm153ko0_10806_1_1 100% 46MB 87.2MB/s 00:00

Archive_20220813_hn153ko0_10807_1_1 100% 20MB 92.6MB/s 00:00

Archive_20220813_hr153koi_10811_1_1 100% 14KB 2.5MB/s 00:00

Controlback_20220813_cf_D-ORCL_id-1607315920_hs153koj 100% 25MB 92.3MB/s 00:00

Fullback_20220813_ho153ko1_10808_1_1 100% 1238MB 123.8MB/s 00:10

Fullback_20220813_hp153ko1_10809_1_1 100% 899MB 112.3MB/s 00:08

Fullback_20220813_hq153kog_10810_1_1 100% 176KB 46.6MB/s 00:00

[oracle@oracledb backup]$

[oracle@oraclesb backup]$ ll

total 2281296

-rw-r-----. 1 oracle oinstall 48598528 Aug 13 23:55 Archive_20220813_hm153ko0_10806_1_1

-rw-r-----. 1 oracle oinstall 20655104 Aug 13 23:55 Archive_20220813_hn153ko0_10807_1_1

-rw-r-----. 1 oracle oinstall 13824 Aug 13 23:55 Archive_20220813_hr153koi_10811_1_1

-rw-r-----. 1 oracle oinstall 26034176 Aug 13 23:55 Controlback_20220813_cf_D-ORCL_id-1607315920_hs153koj

-rw-r-----. 1 oracle oinstall 1298079744 Aug 13 23:55 Fullback_20220813_ho153ko1_10808_1_1

-rw-r-----. 1 oracle oinstall 942481408 Aug 13 23:56 Fullback_20220813_hp153ko1_10809_1_1

-rw-r-----. 1 oracle oinstall 180224 Aug 13 23:56 Fullback_20220813_hq153kog_10810_1_1

[oracle@oraclesb backup]$

Option1:

rman target sys/Mallik123@ORCL

connect auxiliary sys/Mallik123@ORCLSB

run

{

allocate channel p1 type disk;

allocate channel p2 type disk;

allocate channel p3 type disk;

allocate channel p4 type disk;

allocate auxiliary channel s1 type disk;

allocate auxiliary channel s2 type disk;

allocate auxiliary channel s3 type disk;

allocate auxiliary channel s4 type disk;

duplicate target database for standby from active database

spfile

parameter_value_convert 'ORCL','ORCLSB'

set db_name='ORCL'

set db_unique_name='ORCLSB'

set db_file_name_convert '/u01/app/oracle/oradata/ORCL/datafile','/u01/app/oracle/oradata/ORCLSB/datafile'

;

}

[oracle@oraclesb ~]$ rman target sys/Mallik123@ORCL

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Aug 14 00:37:29 2022

Version 19.11.0.0.0

connected to target database: ORCL (DBID=1607315920)

RMAN> connect auxiliary sys/Mallik123@ORCLSB

connected to auxiliary database: ORCL (not mounted)

RMAN> run

{

allocate channel p1 type disk;

2> 3> allocate channel p2 type disk;

allocate channel p3 type disk;

4> 5> allocate channel p4 type disk;

6> 7> allocate auxiliary channel s1 type disk;

allocate auxiliary channel s2 type disk;

8> allocate auxiliary channel s3 type disk;

9> allocate auxiliary channel s4 type disk;

10> 11> duplicate target database for standby from active database

12> spfile

parameter_value_convert 'ORCL','ORCLSB'

13> 14> set db_name='ORCL'

15> set db_unique_name='ORCLSB'

16> set db_file_name_convert '/u01/app/oracle/oradata/ORCL/datafile','/u01/app/oracle/oradata/ORCLSB/datafile'

17> 18> ;

}19>

using target database control file instead of recovery catalog

allocated channel: p1

channel p1: SID=23 device type=DISK

allocated channel: p2

channel p2: SID=390 device type=DISK

allocated channel: p3

channel p3: SID=276 device type=DISK

allocated channel: p4

channel p4: SID=395 device type=DISK

allocated channel: s1

channel s1: SID=10 device type=DISK

allocated channel: s2

channel s2: SID=150 device type=DISK

allocated channel: s3

channel s3: SID=294 device type=DISK

allocated channel: s4

channel s4: SID=434 device type=DISK

Starting Duplicate Db at 14-AUG-22

contents of Memory Script:

{

backup as copy reuse

passwordfile auxiliary format '/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/orapwORCLSB' ;

restore clone from service 'ORCL' spfile to

'/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileORCLSB.ora';

sql clone "alter system set spfile= ''/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileORCLSB.ora''";

}

executing Memory Script

Starting backup at 14-AUG-22

Finished backup at 14-AUG-22

Starting restore at 14-AUG-22

channel s1: starting datafile backup set restore

channel s1: using network backup set from service ORCL

channel s1: restoring SPFILE

output file name=/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileORCLSB.ora

channel s1: restore complete, elapsed time: 00:00:01

Finished restore at 14-AUG-22

sql statement: alter system set spfile= ''/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileORCLSB.ora''

contents of Memory Script:

{

sql clone "alter system set audit_file_dest =

''/u01/app/oracle/admin/ORCLSB/adump'' comment=

'''' scope=spfile";

sql clone "alter system set control_files =

''/u01/app/oracle/oradata/ORCLSB/controlfile/o1_mf_jjhgcrh6_.ctl'', ''/u01/app/oracle/fast_recovery_area/ORCLSB/controlfile/o1_mf_jjhgcrjw_.ctl'' comment=

'''' scope=spfile";

sql clone "alter system set dispatchers =

''(PROTOCOL=TCP) (SERVICE=ORCLSBXDB)'' comment=

'''' scope=spfile";

sql clone "alter system set fal_client =

''ORCLSB'' comment=

'''' scope=spfile";

sql clone "alter system set fal_server =

''ORCLSBSB'' comment=

'''' scope=spfile";

sql clone "alter system set db_name =

''ORCL'' comment=

'''' scope=spfile";

sql clone "alter system set db_unique_name =

''ORCLSB'' comment=

'''' scope=spfile";

sql clone "alter system set db_file_name_convert =

''/u01/app/oracle/oradata/ORCL/datafile'', ''/u01/app/oracle/oradata/ORCLSB/datafile'' comment=

'''' scope=spfile";

sql clone "alter system set log_file_name_convert =

''/u01/app/oracle/oradata/ORCL/onlinelog'', ''/u01/app/oracle/oradata/ORCLSB/onlinelog'', ''/u01/app/oracle/fast_recovery_area/ORCL/onlinelog'', ''/u01/app/oracle/fast_recovery_area/ORCLSB/onlinelog'' comment=

'''' scope=spfile";

shutdown clone immediate;

startup clone nomount;

}

executing Memory Script

sql statement: alter system set audit_file_dest = ''/u01/app/oracle/admin/ORCLSB/adump'' comment= '''' scope=spfile

sql statement: alter system set control_files = ''/u01/app/oracle/oradata/ORCLSB/controlfile/o1_mf_jjhgcrh6_.ctl'', ''/u01/app/oracle/fast_recovery_area/ORCLSB/controlfile/o1_mf_jjhgcrjw_.ctl'' comment= '''' scope=spfile

sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=ORCLSBXDB)'' comment= '''' scope=spfile

sql statement: alter system set fal_client = ''ORCLSB'' comment= '''' scope=spfile

sql statement: alter system set fal_server = ''ORCLSBSB'' comment= '''' scope=spfile

sql statement: alter system set db_name = ''ORCL'' comment= '''' scope=spfile

sql statement: alter system set db_unique_name = ''ORCLSB'' comment= '''' scope=spfile

sql statement: alter system set db_file_name_convert = ''/u01/app/oracle/oradata/ORCL/datafile'', ''/u01/app/oracle/oradata/ORCLSB/datafile'' comment= '''' scope=spfile

sql statement: alter system set log_file_name_convert = ''/u01/app/oracle/oradata/ORCL/onlinelog'', ''/u01/app/oracle/oradata/ORCLSB/onlinelog'', ''/u01/app/oracle/fast_recovery_area/ORCL/onlinelog'', ''/u01/app/oracle/fast_recovery_area/ORCLSB/onlinelog'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area 3707763112 bytes

Fixed Size 8903080 bytes

Variable Size 704643072 bytes

Database Buffers 2986344448 bytes

Redo Buffers 7872512 bytes

allocated channel: s1

channel s1: SID=261 device type=DISK

allocated channel: s2

channel s2: SID=379 device type=DISK

allocated channel: s3

channel s3: SID=10 device type=DISK

allocated channel: s4

channel s4: SID=137 device type=DISK

contents of Memory Script:

{

sql clone "alter system set control_files =

''/u01/app/oracle/oradata/ORCLSB/controlfile/o1_mf_jjhgcrh6_.ctl'', ''/u01/app/oracle/fast_recovery_area/ORCLSB/controlfile/o1_mf_jjhgcrjw_.ctl'' comment=

''Set by RMAN'' scope=spfile";

restore clone from service 'ORCL' standby controlfile;

}

executing Memory Script

Starting restore at 14-AUG-22

channel s1: starting datafile backup set restore

channel s1: using network backup set from service ORCL

channel s1: restoring control file

channel s1: restore complete, elapsed time: 00:00:02

output file name=/u01/app/oracle/oradata/ORCLSB/controlfile/o1_mf_jjhgcrh6_.ctl

output file name=/u01/app/oracle/fast_recovery_area/ORCLSB/controlfile/o1_mf_jjhgcrjw_.ctl

Finished restore at 14-AUG-22

contents of Memory Script:

{

sql clone 'alter database mount standby database';

}

executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:

{

set newname for tempfile 1 to

"/u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_temp_k9ng3t4v_.tmp";

switch clone tempfile all;

set newname for datafile 1 to

"/u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_system_k3jprllp_.dbf";

set newname for datafile 3 to

"/u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_sysaux_k3jps1mq_.dbf";

set newname for datafile 4 to

"/u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_undotbs1_k3jpsjp6_.dbf";

set newname for datafile 5 to

"/u01/app/oracle/oradata/ORCLSB/datafile/test_16k_ts01.dbf";

set newname for datafile 7 to

"/u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_users_k3jpsqnf_.dbf";

restore

from nonsparse from service

'ORCL' clone database

;

sql 'alter system archive log current';

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_temp_k9ng3t4v_.tmp in control file

executing command: SET NEWNAME

Starting restore at 14-AUG-22

channel s1: starting datafile backup set restore

channel s1: using network backup set from service ORCL

channel s1: specifying datafile(s) to restore from backup set

channel s1: restoring datafile 00001 to /u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_system_k3jprllp_.dbf

channel s2: starting datafile backup set restore

channel s2: using network backup set from service ORCL

channel s2: specifying datafile(s) to restore from backup set

channel s2: restoring datafile 00003 to /u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_sysaux_k3jps1mq_.dbf

channel s3: starting datafile backup set restore

channel s3: using network backup set from service ORCL

channel s3: specifying datafile(s) to restore from backup set

channel s3: restoring datafile 00004 to /u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_undotbs1_k3jpsjp6_.dbf

channel s4: starting datafile backup set restore

channel s4: using network backup set from service ORCL

channel s4: specifying datafile(s) to restore from backup set

channel s4: restoring datafile 00005 to /u01/app/oracle/oradata/ORCLSB/datafile/test_16k_ts01.dbf

channel s4: restore complete, elapsed time: 00:00:01

channel s4: starting datafile backup set restore

channel s4: using network backup set from service ORCL

channel s4: specifying datafile(s) to restore from backup set

channel s4: restoring datafile 00007 to /u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_users_k3jpsqnf_.dbf

channel s4: restore complete, elapsed time: 00:00:03

channel s3: restore complete, elapsed time: 00:00:09

channel s1: restore complete, elapsed time: 00:00:17

channel s2: restore complete, elapsed time: 00:00:17

Finished restore at 14-AUG-22

sql statement: alter system archive log current

contents of Memory Script:

{

switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=971 STAMP=1112661539 file name=/u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_system_khhxoty2_.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=972 STAMP=1112661539 file name=/u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_sysaux_khhxov0r_.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=973 STAMP=1112661539 file name=/u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_undotbs1_khhxov2o_.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=974 STAMP=1112661539 file name=/u01/app/oracle/oradata/ORCLSB/datafile/test_16k_ts01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=975 STAMP=1112661539 file name=/u01/app/oracle/oradata/ORCLSB/datafile/o1_mf_users_khhxow6n_.dbf

Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.

RMAN-05535: warning: All redo log files were not defined properly.