Library opens the archive mode, if there is any production downtime, need different machine recovery,
Conditions are as follows: production base A whole database backup exactly 8 o 'clock every morning, noon database downtime, backup set at eight o 'clock in the morning without damage and exist, 8-12 archive log no damage and exist, all online redo logs are lost,
Consult everybody, how should I restore on a different machine, let the data loss is minimized, bother to list steps, thanks again,

CodePudding user response:

Database backup using nocatalog mode

CodePudding user response:

Down, don't take the time to A Mr Khoja, do different machine back?

CodePudding user response:

refer to the second floor selling fruit net reply:

goes down, don't take the time to A Mr Khoja, do different machine to recover?

Just want to simulate if A library after downtime, A library can't use, want to use A different machine recovery operations, but only when the data back to eight, eight points to 12 points of archive logs, don't know how to restore data, also please bosses glad,

CodePudding user response:

The archive logs, rman after restore, recover the application file recovery, finally open resetlogs went, missing data is online redo logs that part of the transaction,

CodePudding user response:

reference XuanXiao, 4/f, 86 response:

the archive logs, rman after restore, recover the application file recovery, finally open resetlogs went, missing data is that part of the online redo logs is transaction,

How to recover the application file recovery, please bosses guidance

CodePudding user response:

reference 5 floor weixin_44048422 reply:

Quote: reference XuanXiao, 4/f, 86 response:

The archive logs, rman after restore, recover the application file recovery, finally open resetlogs went, missing data is that part of the online redo logs is transaction,

How to recover the application file recovery, please bosses guidance from

Under such as file into the directory/arch/rmanbackup/:
The catalog start with '/arch/rmanbackup/noprompt;

RECOVER the DATABASE.

CodePudding user response:

refer to 6th floor XuanXiao 86 response:

Quote: refer to the fifth floor weixin_44048422 reply:

The

Quote: reference XuanXiao, 4/f, 86 response:

The archive logs, rman after restore, recover the application file recovery, finally open resetlogs went, missing data is that part of the online redo logs is transaction,

How to recover the application file recovery, please bosses guidance from

Under such as file into the directory/arch/rmanbackup/:
The catalog start with '/arch/rmanbackup/noprompt;

RECOVER the DATABASE.

Thanks to the guidance of, can already restored, the catalog has been carried out only a little start with directory archive logs, must be backed up after the new archive logs, recover from the backup control file exists inside the archive log can't repeat the catalog start with, or which would be an error recovery,