For details of connecting 2 linux machines using a ethernet cable you can refer to the link below
To take a full database backup you can refer to
To restore a database with an RMAN backup after the database has been dropped
Copy all the backups files from source server alpha to target server beta.
scp oracle@192.168.56.101:/home/oracle/backup/BackupALPHA_DB_013004t3_1_1_1_%S_%P oracle@192.168.56.102:/home/oracle/backup/BackupALPHA_DB_013004t3_1_1_1_%S_%P
scp oracle@192.168.56.101:/home/oracle/backup/BackupALPHA_DB_023004v4_2_1_1_%S_%P oracle@192.168.56.102:/home/oracle/backup/BackupALPHA_DB_023004v4_2_1_1_%S_%P
scp oracle@192.168.56.101:/home/oracle/backup/BackupALPHA_DB_0330058n_3_1_1_%S_%P oracle@192.168.56.102:/home/oracle/backup/BackupALPHA_DB_0330058n_3_1_1_%S_%P
scp oracle@192.168.56.101:/home/oracle/backup/BackupALPHA_DB_043005bc_4_1_1_%S_%P oracle@192.168.56.102:/home/oracle/backup/BackupALPHA_DB_043005bc_4_1_1_%S_%P
scp oracle@192.168.56.101:/home/oracle/backup/BackupALPHA_DB_053005cc_5_1_1_%S_%P oracle@192.168.56.102:/home/oracle/backup/BackupALPHA_DB_053005cc_5_1_1_%S_%P
scp oracle@192.168.56.101:/home/oracle/backup/c-1700090799-20240717-00 oracle@192.168.56.102:/home/oracle/backup/c-1700090799-20240717-00
scp oracle@192.168.56.101:/home/oracle/backup/arch1_1_1174402480.dbf oracle@192.168.56.102:/home/oracle/backup/arch1_1_1174402480.dbf
scp oracle@192.168.56.101:/home/oracle/backup/arch1_2_1174402480.dbf oracle@192.168.56.102:/home/oracle/backup/arch1_2_1174402480.dbf
scp oracle@192.168.56.101:/home/oracle/backup/arch1_3_1174402480.dbf oracle@192.168.56.102:/home/oracle/backup/arch1_3_1174402480.dbf
scp oracle@192.168.56.101:/home/oracle/backup/arch1_4_1174402480.dbf oracle@192.168.56.102:/home/oracle/backup/arch1_4_1174402480.dbf
https://theoraclereference.blogspot.com/2024/07/restore-database-with-rman-backup-after.html
after restore, you can open the database with reset logs.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/ALPHA/system01.dbf'
RMAN> recover database;
Starting recover at 22-MAY-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/22/2024 20:50:08
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover
if needed start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-19912: cannot recover to target incarnation 3
SQL> select fhdbn, fhdbi, hxfil, fhsta, fhscn, fhafs, fhrba_seq, fhtnm tbs_name, substr(hxfnm,1,70) file_name from x$kcvfh
SQL> /
ALPHA 2901288553 1 8192 2694445 0 4
SYSTEM /u01/app/oracle/oradata/ALPHA/system01.dbf
ALPHA 2901288553 3 0 2694445 0 4
SYSAUX /u01/app/oracle/oradata/ALPHA/sysaux01.dbf
ALPHA 2901288553 4 0 2694445 0 4
UNDOTBS1 /u01/app/oracle/oradata/ALPHA/undotbs01.dbf
ALPHA 2901288553 5 8192 2648996 0 3
SYSTEM /u01/app/oracle/oradata/ALPHA/pdbseed/system01.dbf
ALPHA 2901288553 6 0 2648996 0 3
SYSAUX /u01/app/oracle/oradata/ALPHA/pdbseed/sysaux01.dbf
ALPHA 2901288553 7 0 2694445 0 4
USERS /u01/app/oracle/oradata/ALPHA/users01.dbf
ALPHA 2901288553 8 0 2648996 0 3
UNDOTBS1 /u01/app/oracle/oradata/ALPHA/pdbseed/undotbs01.dbf
ALPHA 2901288553 9 8192 2692668 0 4
SYSTEM /u01/app/oracle/oradata/ALPHA/alphapdb1/system01.dbf
ALPHA 2901288553 10 0 2692668 0 4
SYSAUX /u01/app/oracle/oradata/ALPHA/alphapdb1/sysaux01.dbf
ALPHA 2901288553 11 0 2692668 0 4
UNDOTBS1 /u01/app/oracle/oradata/ALPHA/alphapdb1/undotbs01.dbf
ALPHA 2901288553 12 0 2692668 0 4
USERS /u01/app/oracle/oradata/ALPHA/alphapdb1/users01.dbf
ALPHA 2901288553 13 0 2692668 0 4
RMAN_CATALOG /u01/app/oracle/oradata/RMANDBALPHA/rmanalpha_catalog.dbf
12 rows selected.
SQL> alter database backup controlfile to trace;
SQL> shutdown immediate
SQL> startup nomount
SQL>CREATE CONTROLFILE REUSE DATABASE "ALPHA" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 15
MAXLOGHISTORY 292
LOGFILE
GROUP 1 (
'/u01/app/oracle/oradata/ALPHA/redo01.log',
'/u01/app/oracle/fast_recovery_area/ALPHA/redo01.log'
) SIZE 200M BLOCKSIZE 512,
GROUP 2 (
'/u01/app/oracle/oradata/ALPHA/redo02.log',
'/u01/app/oracle/fast_recovery_area/ALPHA/redo02.log'
) SIZE 200M BLOCKSIZE 512,
GROUP 3 (
'/u01/app/oracle/oradata/ALPHA/redo03.log',
'/u01/app/oracle/fast_recovery_area/ALPHA/redo03.log'
) SIZE 200M BLOCKSIZE 512
DATAFILE
'/u01/app/oracle/oradata/ALPHA/system01.dbf',
'/u01/app/oracle/oradata/ALPHA/sysaux01.dbf',
'/u01/app/oracle/oradata/ALPHA/undotbs01.dbf',
'/u01/app/oracle/oradata/ALPHA/pdbseed/system01.dbf',
'/u01/app/oracle/oradata/ALPHA/pdbseed/sysaux01.dbf',
'/u01/app/oracle/oradata/ALPHA/users01.dbf',
'/u01/app/oracle/oradata/ALPHA/pdbseed/undotbs01.dbf',
'/u01/app/oracle/oradata/ALPHA/alphapdb1/system01.dbf',
'/u01/app/oracle/oradata/ALPHA/alphapdb1/sysaux01.dbf',
'/u01/app/oracle/oradata/ALPHA/alphapdb1/undotbs01.dbf',
'/u01/app/oracle/oradata/ALPHA/alphapdb1/users01.dbf',
'/u01/app/oracle/oradata/RMANDBALPHA/rmanalpha_catalog.dbf'
CHARACTER SET AL32UTF8;
controlfile created.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-65088: database open should be retried
Process ID: 15265
Session ID: 271 Serial number: 59691
SQL> shutdown immediate;
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2717907456 bytes
Fixed Size 9689600 bytes
Variable Size 620756992 bytes
Database Buffers 2080374784 bytes
Redo Buffers 7086080 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> alter database open;
Database altered.
SQL> alter pluggable database all open;
ERROR at line 1:
ORA-01190: control file or data file 9 is from before the last RESETLOGS
ORA-01110: data file 1: '/u01/app/oracle/oradata/ALPHA/alphapdb1/system01.dbf'
RMAN> recover pluggable database alphapdb1;
RMAN> recover pluggable database alphapdb1;
Starting recover at 22-MAY-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=279 device type=DISK
starting media recovery
archived log for thread 1 with sequence 1 is already on disk as file /u01/app/oracle/homes/OraDB21Home3/dbs/arch1_1_1169673954.dbf
archived log file name=/u01/app/oracle/homes/OraDB21Home3/dbs/arch1_4_1174402480.dbf thread=1 sequence=4
media recovery complete, elapsed time: 00:00:04
Finished recover at 22-MAY-24
SQL> alter pluggable database all open;
PLuggable database altered.
Thought for the Day
Do not enter the path of the wicked,
and do not walk in the way of evildoers.
Avoid it; do not go on it;
turn away from it and pass on.
For they cannot sleep unless they have done wrong;
They are robbed of sleep unless they have made someone stumble.
Proverbs 4: 14-16
No comments:
Post a Comment