RMAN Configuration for 2 nodes RAC Database
Hi, How to create rman catalog and register database for 2 nodes RAC. Is the procedure same as of single database. I want to take backup using RMAN by creating catalog and registering RAC database on another Sun server consists of oracle 9i database, for my 2 nodes oracle 9i RAC database.
All the datafiles are stored in SAN storage and for archivelogs the drive is shared for the two nodes.
thanks,
RMAN Configuration for 2 nodes RAC Database
Hi, I have gone through the Oracle 9i RMAN documentation of oracle press. But sorry to say that I didn't found the method for creating catalog and registering the target RAC database in the manual.
My question is:
Is it the same procedure to create catalog and register database for RAC DB with 2 nodes as of Single Production DB.
since there are two nodes and a shared external storage which contains database files and archive logs, when I register the target database in recovery catalog database which is on different system and issue the RMAN>backup database plus archivelog; does archive logs are backed up from both the nodes along with datafiles.
Thanks,
RMAN Configuration for 2 nodes RAC Database
Hi, thanks for the answers.
Currently Iam taking RMAN full weekly backups on node 1, I can store only one weekly backup on node 1 due to space shortage. So first I delete the previous weekly backup before taking new weekly backup.
After successfully taking the backup using
RMAN>backup database plus archivelog;
the backup files are written to disk and on tape.
But when I issue
RMAN>crosscheck backup completed before 'sysdate';
RMAN shows the latest backup files as "Expired". It should have shown as "Available" as the files are physically present on disk, i have not deleted the latest backup files.
Note: My catalog database is on another solaris machine.
Question: Why RMAN is not treating the latest backup files as Available.
One more thing: Iam getting a Solaris operating system message on node 1 as,
message overflow on /dev/log minor #6 -- is syslogd (1M) running?
Question: Is this the reason RMAN is not treating the files as Available, but it is reading the directory as it is displaying the backup files as Expired.
Your kind help is appreciated,
thanks,
RMAN Configuration for 2 nodes RAC Database
Hi, I go to rman backup directory and give rm* command, to delete the backup files from operating system.
thanks,
RMAN Configuration for 2 nodes RAC Database
Hi, Hrishy you have understood my case. please help me to solve this problem.
Note: the os command $scstat -p, shows one of the resource
Infra as online but Degraded - IPMP Failure
this error is on node 1 on which Iam taking backups, is this the reason RMAN showing the latest backups as Expired eventhough they exists on disk.
thanks,
RMAN Configuration for 2 nodes RAC Database
Hi, first sorry for delay in replying to your message.
Hrishy, this is the output of the command that you have asked for. It is not displaying any backups records.
RMAN> crosscheck backup completed
2> between 'sysdate' and 'sysdate-30';
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1
RMAN>
thanks and regards,