Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Backuping up a standby database in a Data Guard environment!

Latvian83Apr 3 2011 — edited Apr 3 2011
Hello everyone,

I have set a Data Guard in Oralce 10.2.0 between 2 databases for testing purposes. Each database is located on a different server. I want to schedule an incremental backup of the standby database to do an incremental level_1 backup everyday. I am following this paper:

[Using Recovery Manager with Oracle Data Guard in Oracle Database 10g|http://www.oracle.com/technetwork/database/features/availability/rman-dataguard-10g-wp-1-129486.pdf]

but it's really unclear, for me, how this command sequence is constructed:
RECOVER COPY OF DATABASE WITH TAG ‘OSS’; 
BACKUP DEVICE TYPE DISK INCREMENTAL LEVEL 1 FOR 
RECOVER OF COPY WITH TAG ‘OSS’ DATABASE; 
BACKUP ARCHIVELOG ALL NOT BACKED UP TO SBT; 
BACKUP BACKUPSET ALL;
How can I recover a copy of database that wasn't backed up before? When I did that in RMAN, I got the following output:
Starting recover at 03-APR-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
no copy of datafile 5 found to recover
Finished recover at 03-APR-11
Could anyone please help me understanding this sequence of commands in a simple way to get a better idea of how to backup a standby database?

Thanks in advance...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2011
Added on Apr 3 2011
1 comment
185 views