Register | Login

Published Articles » Oracle

ORACLE RMAN CLONE WITH AUXILIARY

Posted by venky (#73) 2365 days ago (Editorial)
1) CREATE PFILE WITH DB_FILE_NAME_CONVERT=(OLD PATH,NEW PATH)
2) CREATE DIRECTORY STRUCTURES AS PER PFILE.
3) RMAN TARGET SYS/PASSWORD@TNSNAMES AUXILIARY /
RUN
{
ALLOCATE CHANNEL D1 DEVICE TYPE DISK FORMAT 'BACKUP LOCATION';
DUPLICATE TARGET DATABASE TO NEW DB NAME;
}


ORACLE DATAGUARD FAILOVER

Posted by venky (#73) 2365 days ago (Editorial)

6.2 Failover from the Primary to the Standby Database (Disaster Recovery)
Perform following tasks to do failover:

1. Identify and resolve any archivelog gaps. On the standby database server, execute the following statement:
SQL> select * from v$archive_gap;
no rows selected
If this query returns any rows, copy the archivelogs file to the primary site and check whether is is applied
Sort News
Username:

Password:

Remember:
YourWiz.com, is a website that will allow everyone to share their knowledge, tip or information through community micro blogging.