Database Backup and Recovery (MOSC)

MOSC Banner

Recovering database copy from archived redologs

edited Jul 21, 2018 5:05AM in Database Backup and Recovery (MOSC) 2 commentsAnswered

Hello,

I have a question on recovering a database copy.
Environmentt:
Oracle RDBMS 12.1.0.2 on exadata
Database is running in RAC mode on 4 nodes, exadata is connected to a ZFSSA via infiniband.
Because the database got too big, has a lot of daily changes and ZFSSA ran out of space,
I'd like to recover the database copy from the backups of archived redologs, using the until-clause.
Until now I used:
( allocate channel device type disk...;
  recover copy of database with tag 'DATABASE_COPY';
  backup as compressed backupset filesperset 1 incremental level 1 for recover of copy with tag 'DATABASE_COPY' database;
  ZFSSA-Snapshot )

The new approach would omit

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