Rman remote recovery process log 03/25 Update SLTechnology News&Howtos

Rman remote recovery process log

2025-03-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Shulou(Shulou.com)06/01 Report--

Backup script https://blog.51cto.com/860143/2413679

[oracle@localhost dbs] $ll

Total dosage 8

-rw-rw---- 1 oracle oinstall 1552 December 25 11:08 hc_TSH1.dat

-rw-r--r-- 1 oracle oinstall 1091 December 25 09:26 initTSH1.ora

[oracle@localhost dbs] $rman target /

Recovery Manager: Release 10.2.0.1.0-Production on Wed Dec 25 11:21:24 2019

Connected to target database (not started)

RMAN > startup nomount

Oracle instance started

Total System Global Area 1224736768 bytes

Fixed Size 2020384 bytes

Variable Size 318770144 bytes

Database Buffers 889192448 bytes

Redo Buffers 14753792 bytes

RMAN > exit

Recovery Manager complete.

[oracle@localhost dbs] $ll / u01/app/backup/

The total dosage is 10995524

-rw-r- 1 oracle oinstall 14179328 December 19 01:13 rman_arch_KEHLCOM_23806_20191219_1_7uujpbeb_1_1.bkupset

-rw-r- 1 oracle oinstall 11728384 December 19 01:13 rman_arch_KEHLCOM_23807_20191219_1_7vujpbeb_1_1.bkupset

-rw-r- 1 oracle oinstall 2560 December 19 01:13 rman_arch_KEHLCOM_23808_20191219_1_80ujpbeb_1_1.bkupset

-rw-r- 1 oracle oinstall 13533184 December 19 01:13 rman_control_7sujpbe3_1_1.ctl

-rw-r- 1 oracle oinstall 5725913088 December 19 01:13 rman_db_KEHLCOM_23799_20191219_1_7nujpal1_1_1.bkupset

-rw-r- 1 oracle oinstall 2552856576 December 19 01:07 rman_db_KEHLCOM_23800_20191219_1_7oujpal1_1_1.bkupset

-rw-r- 1 oracle oinstall 2939002880 December 19 01:09 rman_db_KEHLCOM_23801_20191219_1_7pujpal1_1_1.bkupset

-rw-r- 1 oracle oinstall 1998848 December 19 01:07 rman_db_KEHLCOM_23802_20191219_1_7qujpb2k_1_1.bkupset

-rw-r- 1 oracle oinstall 98304 December 19 01:07 rman_db_KEHLCOM_23803_20191219_1_7rujpb2m_1_1.bkupset

-rw-r- 1 oracle oinstall 98304 December 19 01:13 kehl_spfile_7tujpbe4_1_1

[oracle@localhost dbs] $rman target /

Recovery Manager: Release 10.2.0.1.0-Production on Wed Dec 25 11:23:21 2019

Connected to target database: kehlcom (not mounted)

RMAN > restore spfile from'/ u01 ActionAccording to backupAccording to KehlGreenspfileAccording to 7tujpbe4

Starting restore at 25-DEC-19

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid=431 devtype=DISK

Channel ORA_DISK_1: autobackup found: / u01/app/backup/kehl_spfile_7tujpbe4_1_1

Channel ORA_DISK_1: SPFILE restore from autobackup complete

Finished restore at 25-DEC-19

RMAN > shutdown immediate

Oracle instance shut down

RMAN > exit

Recovery Manager complete.

[oracle@localhost dbs] $ll

Total dosage 12

-rw-rw---- 1 oracle oinstall 1552 December 25 11:23 hc_TSH1.dat

-rw-r--r-- 1 oracle oinstall 1091 December 25 09:26 initTSH1.ora

-rw-r- 1 oracle oinstall 3584 December 25 11:23 spfileTSH1.ora

[oracle@localhost dbs] $strings spfileTSH1.ora

Kehlcom.db_cache_size=8237613056

Kehlcom.java_pool_size=16777216

Kehlcom.large_pool_size=16777216

Kehlcom.shared_pool_size=301989888

Kehlcom.streams_pool_size=0

.audit _ file_dest='/u01/oracle/admin/kehlcom/adump'

.audit _ sys_operations=TRUE

.audit _ trail='db','extended'

.background _ dump_dest='/u01/oracle/admin/kehlcom/bdump'

.control _ files='/u01/oradata/kehlcom/control1.ctl','/u01/oradata/kehlcom/control2.ctl','/u01/oradata/kehlcom/control3.','ctl'

.core _ dump_dest='/u01/oracle/admin/kehlcom/cdump'

.db _ block_size=8192

.db _ create_file_dest='/u01/oradata'

.db _ create_online_log_dest_1='/u01/oradata'

.db _ domain='kehlcom'

.db _ name='kehlcom'

.db _ recovery_file_dest_size=21474836480

.db _ recovery_file_dest='/u01/arch/flashbakdb'

.db _ unique_name='kehlcom'

.job _ queue_processes=10

.log _ archive_dest_1='LOCATION=/u01/arch/kehlcom'

.log _ archiveformat='log%t%s%r.arc'

.open _ cursors=1500

.percent = 400

.sga _ max_size=8192M

.sga _ target=8192M

.undo _ management='AUTO'

.undo _ retention=10800

.undo _ tablespace='UNDOTBS1'

* .user_dump_dest='/u01/oracle/admin/kehlcom/udump'

[oracle@localhost dbs] $strings spfileTSH1.ora > initTSH1.ora

[oracle@localhost dbs] $rm initTSH1.ora

[oracle@localhost dbs] $cp / tmp/initTSH1.ora.

[oracle@localhost dbs] $cat initTSH1.ora

Kehlcom.db_cache_size=838860800

Kehlcom.java_pool_size=16777216

Kehlcom.large_pool_size=16777216

Kehlcom.shared_pool_size=251658240

Kehlcom.streams_pool_size=0

.audit _ file_dest='/u01/oracle/admin/kehlcom/adump'

.audit _ sys_operations=TRUE

.audit _ trail='db','extended'

.background _ dump_dest='/u01/oracle/admin/kehlcom/bdump'

.control _ files='/u01/oradata/kehlcom/control1.ctl','/u01/oradata/kehlcom/control2.ctl','/u01/oradata/kehlcom/control3.ctl'

.core _ dump_dest='/u01/oracle/admin/kehlcom/cdump'

.db _ block_size=8192

.db _ create_file_dest='/u01/oradata'

.db _ create_online_log_dest_1='/u01/oradata'

.db _ domain='kehlcom'

.db _ name='kehlcom'

.db _ recovery_file_dest_size=21474836480

.db _ recovery_file_dest='/u01/arch/flashbakdb'

.db _ unique_name='kehlcom'

.job _ queue_processes=10

.log _ archive_dest_1='LOCATION=/u01/arch/kehlcom'

.log _ archiveformat='log%t%s%r.arc'

.open _ cursors=1500

.percent = 400

.sga _ target=1210056704

.undo _ management='AUTO'

.undo _ retention=10800

.undo _ tablespace='UNDOTBS1'

.user _ dump_dest='/u01/oracle/admin/kehlcom/udump'

[oracle@localhost dbs] $mkdir-p / u01/oracle/admin/kehlcom/adump

Mkdir-p / u01/oracle/admin/kehlcom/bdump

[oracle@localhost dbs] $mkdir-p / u01/oracle/admin/kehlcom/bdump

[oracle@localhost dbs] $mkdir-p / u01/oradata/kehlcom/

[oracle@localhost dbs] $mkdir-p / u01/oracle/admin/kehlcom/cdump

[oracle@localhost dbs] $mkdir-p / u01/arch/flashbakdb

[oracle@localhost dbs] $mkdir-p / u01/arch/kehlcom

[oracle@localhost dbs] $mkdir-p / u01/oracle/admin/kehlcom/udump

[oracle@localhost dbs] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0-Production on Wed Dec 25 11:25:48 2019

Connected to an idle instance.

SQL > startup nomount pfile=/u01/app/oracle/product/10.2.0/db_1/dbs/initTSH1.ora

ORACLE instance started.

Total System Global Area 1224736768 bytes

Fixed Size 2020384 bytes

Variable Size 318770144 bytes

Database Buffers 889192448 bytes

Redo Buffers 14753792 bytes

SQL > create spfile from pfile

File created.

SQL > exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production

With the Partitioning, OLAP and Data Mining options

[oracle@localhost dbs] $strings spfileTSH1.ora

QroomE =

Kehlcom.db_cache_size=838860800

Kehlcom.java_pool_size=16777216

Kehlcom.large_pool_size=16777216

Kehlcom.shared_pool_size=251658240

Kehlcom.__streams_pool_size=0

.audit _ file_dest='/u01/oracle/admin/kehlcom/adump'

.audit _ sys_operations=TRUE

.audit _ trail='db','extended'

.background _ dump_dest='/u01/oracle/admin/kehlcom/bdump'

.control _ files='/u01/oradata/kehlcom/control1.ctl','/u01/oradata/kehlcom/control2.ctl','/u01/oradata/kehlcom/control3.ctl'

.core _ dump_dest='/u01/oracle/admin/kehlcom/cdump'

.db _ block_size=8192

.db _ create_file_dest='/u01/oradata'

.db _ create_online_log_dest_1='/u01/oradata'

.db _ domain='kehlcom'

.db _ name='kehlcom'

.db _ recovery_file_dest_size=21474836480

.db _ recovery_file_dest='/u01/arch/flashbakdb'

.db _ unique_name='kehlcom'

.job _ queue_processes=10

.log _ archive_dest_1='LOCATION=/u01/arch/kehlcom'

.log _ archiveformat='log%t%s%r.arc'

.open _ cursors=1500

.percent = 400

.sga _ target=1210056704

.undo _ management='AUTO'

.undo _ retention=10800

.undo _ tablespace='UNDOTBS1'

.user _ dump_dest='/u01/oracle/admin/kehlcom/udump'

[oracle@localhost dbs] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0-Production on Wed Dec 25 11:27:26 2019

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production

With the Partitioning, OLAP and Data Mining options

SQL > shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL > exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production

With the Partitioning, OLAP and Data Mining options

[oracle@localhost dbs] $rman target /

Recovery Manager: Release 10.2.0.1.0-Production on Wed Dec 25 11:27:58 2019

Connected to target database (not started)

RMAN > startup nomount

Oracle instance started

Total System Global Area 1224736768 bytes

Fixed Size 2020384 bytes

Variable Size 318770144 bytes

Database Buffers 889192448 bytes

Redo Buffers 14753792 bytes

RMAN > restore controlfile from'/ u01According to BackupPlacement, rmancy control7sujpbe3percent 1.ctl'

Starting restore at 25-DEC-19

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid=431 devtype=DISK

Channel ORA_DISK_1: restoring control file

Channel ORA_DISK_1: restore complete, elapsed time: 00:00:02

Output filename=/u01/oradata/kehlcom/control1.ctl

Output filename=/u01/oradata/kehlcom/control2.ctl

Output filename=/u01/oradata/kehlcom/control3.ctl

Finished restore at 25-DEC-19

RMAN > alter database mount

Database mounted

Released channel: ORA_DISK_1

RMAN > crosscheck backup

Starting implicit crosscheck backup at 25-DEC-19

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid=431 devtype=DISK

Allocated channel: ORA_DISK_2

Channel ORA_DISK_2: sid=430 devtype=DISK

Crosschecked 5 objects

Crosschecked 54 objects

Finished implicit crosscheck backup at 25-DEC-19

Starting implicit crosscheck copy at 25-DEC-19

Using channel ORA_DISK_1

Using channel ORA_DISK_2

Finished implicit crosscheck copy at 25-DEC-19

Searching for all files in the recovery area

Cataloging files...

No files cataloged

Using channel ORA_DISK_1

Using channel ORA_DISK_2

Crosschecked backup piece: found to be 'AVAILABLE'

Backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23800_20191219_1_7oujpal1_1_1.bkupset recid=23475 stamp=1027386017

Crosschecked backup piece: found to be 'AVAILABLE'

Backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23802_20191219_1_7qujpb2k_1_1.bkupset recid=23476 stamp=1027386453

Crosschecked backup piece: found to be 'AVAILABLE'

Backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23803_20191219_1_7rujpb2m_1_1.bkupset recid=23477 stamp=1027386455

Crosschecked backup piece: found to be 'AVAILABLE'

Backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23801_20191219_1_7pujpal1_1_1.bkupset recid=23478 stamp=1027386017

Crosschecked backup piece: found to be 'AVAILABLE'

Backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23799_20191219_1_7nujpal1_1_1.bkupset recid=23479 stamp=1027386017

Crosschecked 5 objects