Database Backup and Recovery (MOSC)

MOSC Banner

How to set until time in the restore database

edited May 21, 2014 12:00PM in Database Backup and Recovery (MOSC) 12 commentsAnswered

I want to restore March 5th' backup, attached is my backup log file

Here is my restore script, I used finished backup time in the restore which is at the end of backup. Could someone check if I use the right time in the set until time clause? Thanks.

RMAN> run {

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=pclcdb04,NB_ORA_POLICY=lc_or_pclcdb04_qdb_crsp_hot)';

ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=pclcdb04,NB_ORA_POLICY=lc_or_pclcdb04_qdb_crsp_hot)';

ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=pclcdb04,NB_ORA_POLICY=lc_or_pclcdb04_qdb_crsp_hot)';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center