Redshift Disaster Recovery, attempting to restore tables to cluster in another account.

1 -- if you want to just have only few tables and schema available to DR site on you can unload on S3 and load it to DR site Cluster when needed.

2 -- You can also run dual ETL to load data in primary and DR cluster for specific tables. For both option 1 & 2 You can use Redshift Serverless as a DR cluster, which will be auto paused when not being used and will be available in minutes when you need it.

3 -- AZ Failure - You may want to look into CROSS AZ Relocation feature of Redshift. This will have fail over cluster available with no data loss and will be available in minutes. https://docs.aws.amazon.com/redshift/latest/mgmt/managing-cluster-recovery.html

4 -- Region Failure - You can enable cross region snapshot to copy data in other region in a automated fashion and restore it to the DR cluster when required. https://aws.amazon.com/blogs/aws/automated-cross-region-snapshot-copy-for-amazon-redshift/