43 lines
1.2 KiB
Plaintext
Executable File
43 lines
1.2 KiB
Plaintext
Executable File
oracle@bakura[EWOKPRD]:/mnt/yavin4/tmp/_oracle_/tmp$ cat listener.ora
|
|
|
|
MYLSNR =
|
|
(DESCRIPTION_LIST =
|
|
(DESCRIPTION =
|
|
(ADDRESS = (PROTOCOL = TCP)(HOST = bakura)(PORT = 1600))
|
|
)
|
|
)
|
|
|
|
SID_LIST_MYLSNR =
|
|
(SID_LIST =
|
|
(SID_DESC =
|
|
(GLOBAL_DBNAME = EWOKPRD_STATIC)
|
|
(SID_NAME = EWOKPRD)
|
|
(ORACLE_HOME = /app/oracle/product/19)
|
|
)
|
|
)
|
|
|
|
|
|
export TNS_ADMIN=/mnt/yavin4/tmp/_oracle_/tmp
|
|
lsnrctl start MYLSNR
|
|
lsnrctl status MYLSNR
|
|
|
|
|
|
connect sys/"*****"@//bakura:1600/EWOKPRD_STATIC as sysdba
|
|
connect sys/"*****"@//togoria:1521/ANDOPRD as sysdba
|
|
|
|
|
|
rman target=sys/"*****"@//togoria:1521/ANDOPRD auxiliary=sys/"*****"@//bakura:1600/EWOKPRD_STATIC
|
|
run {
|
|
allocate channel pri1 device type DISK;
|
|
allocate channel pri2 device type DISK;
|
|
allocate channel pri3 device type DISK;
|
|
allocate channel pri4 device type DISK;
|
|
allocate auxiliary channel aux1 device type DISK;
|
|
allocate auxiliary channel aux2 device type DISK;
|
|
allocate auxiliary channel aux3 device type DISK;
|
|
allocate auxiliary channel aux4 device type DISK;
|
|
duplicate target database to 'EWOK'
|
|
from active database
|
|
using compressed backupset section size 1G;
|
|
}
|